How I use SUMIF & AND

  • Thread starter Thread starter rajgopal
  • Start date Start date
R

rajgopal

Thanks for your help.

Can I use AVERAGE function also instead of SUM?
 
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
 
You must log in or register to reply here.

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

SUMIF with criteria "<>" & "=" 4
Nesting SUMIF within SUMPRODUCT 10
Combine Sumif and Countif 3
subtotal with sumif nested 1
SUMIF function 3
Sumif Function 1
sumif of non-adjacent cells 1
Sumif Function 2

Back
Top