AVERAGEIF formula with 2 sets of criteria

Options

Hi! I was able to use the following formula to pull data based on 1 set of criteria.

=AVERAGEIF({Range 1}, MONTH(@cell) = 7, {Range 2})

So, if range 1 includes data for the month of July, return the average of that data set in range 2.


However, now I want to further segment by type of data. But my formula is not working. What should I change?

=AVERAGEIF({Range 1}, MONTH(@cell) = 7, {Range 3}, "Google", {Range 2})

I'm trying to get the average of data that is in the month of July AND is identified as Google in range 3, then return the average of that data set in range 2.


Can anyone please help me figure out what I have wrong?

Thanks!

Cindi

Best Answer

Answers