Blogs about: Max Function In Google Docs

Featured Blog

Maximum Based on Multiple Criteria

  The Formula in cell G2 is =ArrayFormula(MAX(IF(A2:A12=E2,IF(B2:B12=F2,C2:C12)))) the above formula will return the maximum value in cell C2:C12 corresponding to criteria specified in the cell E… more →

anandexcels

Maximum Based on Multiple Criteria

anandexcels wrote 1 year ago:   The Formula in cell G2 is =ArrayFormula(MAX(IF(A2:A12=E2,IF(B2:B12=F2,C2:C12)))) the above fo … more →

Tags: functions, GOOGLE DOCS, google docs spread sheets, max function, IF function


Related Tags
All →

Follow this tag via RSS