Calculate average across rows that match an ID and a word - Google Sheets

Question

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.

marikamitsos · Accepted Answer · 2020-06-18 01:00:48Z

1

EDIT
(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

answered Jun 18, 2020 at 0:18

marikamitsos

13.1k4 gold badges34 silver badges59 bronze badges

Thank you. Can it output only the avg value and not the "Average if ABC/Yes" label?
– Nicolas Hung
Commented Jun 18, 2020 at 0:27
Please see the edited answer.Also, please remember that as per site guidelines when an answer addresses your question, you should accept it and even upvote it so others can benefit as well.
– marikamitsos
Commented Jun 18, 2020 at 1:02
Amazing, thank you!
– Nicolas Hung
Commented Jun 18, 2020 at 1:57

Add a comment |

1 Answer 1