How I use SUMIF & AND

D

Domenic

rajgopal said:
Thanks for your help.

Can I use AVERAGE function also instead of SUM?
Click to expand...

Yes. You can use Paul's formula and change SUM to AVERAGE...

=AVERAGE(IF((A2:A10="east")*(B2:B10="type A"),C2:C10))

...entered using CONTROL+SHIFT+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

Use TODAY() function as the criteria in a SUMIF formula 1
Combine Sumifs with Subtotal 0
SUMIF with criteria "<>" & "=" 4
Multiple Columns in Sum Range using SUMIFS 1
sumif issues 1
Sum data using sumif 3
Help on the Sumif Function 1
Help with SUMIFS 2

Top