|Google docs does not have AVERAGEIF and LOOKUP functions||wfeg||7/2/09 6:54 PM|
My uploaded spreadsheet uses AVERAGEIF and LOOKUP functions, but Google spreadsheet does not support these funcftions.
Is Google docs intending to implement more functions, including AVERAGEIF and LOOKUP functions? I have other spreadsheets that require also that SUMIF function.
|Re: Google docs does not have AVERAGEIF and LOOKUP functions||ahab||7/3/09 1:44 AM|
Google has the FILTER function which allows you to create formulas with the same behaviour as AVERAGEIF, LOOKUP and SUMIF
|Re: Google docs does not have AVERAGEIF and LOOKUP functions||bmoore16||7/9/09 10:12 AM|
I need to do an AverageIf comparable in GoogleDocs but how does it look if I need to do multiple IFS or FILTERS? ....or is it possible in GoogleDocs
|Re: Google docs does not have AVERAGEIF and LOOKUP functions||ahab||7/9/09 11:38 AM|
If you mean you need more conditions, this is simple using FILTERs, just add aother condition; all condition resuls are automatically logically ANDed with each other.
Average the numbers in A2:A10 where the numbers in B2B10 are > 0 and <=10 :
=AVERAGE( FILTER( A2:A10 ; B2:B10>0 ; B2:B10<=10 ))
Or do you mean something different?