Help please with sumif when mutiple ranges

  • Thread starter Thread starter Paul Marsh
  • Start date Start date
P

Paul Marsh

Could someone please help me sum the contents of one column, only whe
they match the criteria from two other columns. Crude example; sumi
A:A=Red AND B:B=Pink, sum C:
 
Paul said:
Could someone please help me sum the contents of one column, only whe
they match the criteria from two other columns. Crude example; sumi
A:A=Red AND B:B=Pink, sum C:C

Hi Paul

Try this > =SUM(IF(A:A="Red",IF(B:B="Pink",C:C,0),0)
 

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

Back
Top