Trying to average col c if col a = "value" and col b = "value2"

M

MBS

I'm having a hard time sorting the format of the formula out - any assistance
is appreciated.
 
T

T. Valko

Try this array formula** :

E1 = value1
F1 = value2

=AVERAGE(IF((A1:A10=E1)*(B1:B10=F1),C1:C10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Average, Count, Min & Max against a range of Values 0
Multiple Criteria Lookup 3
Lookup Formula 4
How to get the count and average of values in reference to anotherrange of data 3
Sumproduct seems off... HELP PLEASE! 3
vlookup, indexing, oh my.... 4
Counting unique values in multiple columns 4
Averaging many non-contiguous cells if they are blank 1

Top