Table is as follows:
I want calculate the average of values in column C for rows with value "ABC" in column A and value "Yes" in column B.
So, basically, the average of values 2 and 4.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
(following OP's request)
To completely skip any header (display nothing instead of
some words) please use
=QUERY(A1:C4,"select avg(C) where A='ABC' and B='Yes' label avg(C) '' ")
Please notice the pair of single quotes in the end
You can use this query formula:
=QUERY(A1:C4,"select avg(C) where A='ABC' and B='Yes' label avg(C) 'Average if ABC/Yes' ")
More about QUERY