Skip to main content

Home/ academic technology/ Group items tagged countifs

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
Matthew Ragan

Equivelent of "COUNTIFS" function in excel - Google Docs Help - 0 views

www.google.com.tw/...thread

excel equivelent countifs google spreadsheets google spreadsheets web2.0

shared by Matthew Ragan on 27 May 11 - No Cached
  • Matthew Ragan on 27 May 11
     
    I am trying to count cells based on multiple criteria from multiple cell ranges using google docs.  In Excel the formula is simply: =COUNTIFS(S2:S26, "IN", E2:E26, "A") This would select all of the cells with the word "IN" and the Letter "A" in the same corresponding row.  Can anyone help me figure out a workaround for not being able to use the "countifs" function in google spreadsheet?
Matthew Ragan

Function list : Functions - Google Docs Help - 1 views

docs.google.com/...answer.py

google functions formula spreadsheets data

shared by Matthew Ragan on 15 Mar 11 - No Cached
  • Frequency distribution
  • FREQUENCY(data, classes)
  • FILTER(sourceArray, arrayCondition_1, arrayCondition_2, ..., arrayCondition_30)
  • ...21 more annotations...
  • SORT(data, keyColumn_1, ascOrDesc_1, keyColumn_2, ascOrDesc_2, ..., keyColumn_30, ascOrDesc_30)
  • Cross-workbook referenceImportRange(spreadsheet_key, [sheet!]range)
  • Elements based on criteriaCOUNTIF(range, criteria)
  • RANDBETWEEN (bottom, top)Returns an integer random number between bottom and top (inclusive).
  • ROUND(number, count)Rounds the given number to a certain number of decimal places according to valid mathematical criteria. Count (optional) is the number of the places to which the value is to be rounded. If the count parameter is negative, only the whole number portion is rounded. It is rounded to the place indicated by the count.
  • RAND()Returns a random number between 0 and 1.
  • AVERAGE(number_1, number_2, ... number_30)Returns the average of the arguments. Number_1, number_2, ... number_30 are numerical values or ranges. Text is ignored.
  • CONFIDENCE(alpha, STDEV, size)Returns the (1-alpha) confidence interval for a normal distribution. Alpha is the level of the confidence interval. STDEV is the standard deviation for the total population. Size is the size of the total population.
  • CORREL(data_1, data_2)Returns the correlation coefficient between two data sets. Data_1 is the first data set. Data_2 is the second data set.
  • COUNT(value_1, value_2, ... value_30)Counts how many numbers are in the list of arguments. Text entries are ignored. Value_1, value_2, ... value_30 are values or ranges which are to be counted.
  • COUNTA(value_1, value_2, ... value_30)Counts how many values are in the list of arguments. Text entries are also counted, even when they contain an empty string of length 0. If an argument is an array or reference, empty cells within the array or reference are ignored. value_1, value_2, ... value_30 are up to 30 arguments representing the values to be counted.
  • MAX(number_1, number_2, ... number_30)Returns the maximum value in a list of arguments. Number_1, number_2, ... number_30 are numerical values or ranges.
  • MEDIAN(number_1, number_2, ... number_30)Returns the median of a set of numbers. Number_1, number_2, ... number_30 are values or ranges, which represent a sample. Each number can also be replaced by a reference.
  • MIN(number_1, number_2, ... number_30)Returns the minimum value in a list of arguments. Number_1, number_2, ... number_30 are numerical values or ranges.
  • MODE(number_1, number_2, ... number_30)Returns the most common value in a data set. Number_1, number_2, ... number_30 are numerical values or ranges. If several values have the same frequency, it returns the smallest value. An error occurs when a value does not appear twice.
  • PERCENTILE(data, alpha)Returns the alpha-percentile of data values in an array. Data is the array of data. Alpha is the percentage of the scale between 0 and 1.
  • QUARTILE(data, type)Returns the quartile of a data set. Data is the array of data in the sample. Type is the type of quartile. (0 = Min, 1 = 25%, 2 = 50% (Median), 3 = 75% and 4 = Max.)
  • RANK(value, data, type)Returns the rank of the given Value in a sample. Data is the array or range of data in the sample. Type (optional) is the sequence order, either ascending (0) or descending (1).
  • STDEV(number_1, number_2, ... number_30)Estimates the standard deviation based on a sample. Number_1, number_2, ... number_30 are numerical values or ranges representing a sample based on an entire population.
  • STDEVP(number_1, number_2, ... number_30) Calculates the standard deviation based on the entire population. Number_1, number_2, ... number_30 are numerical values or ranges representing a sample based on an entire population.
  • Combines text stringsCONCATENATE(text_1, text_2, ..., text_30)Combines several text strings into one string. Text_1, text_2, ... text_30 are text passages that are to be combined into one string.
  • Matthew Ragan on 15 Mar 11
     
    Google Spreadsheets Formula Help
1 - 2 of 2
Showing 20▼ items per page