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
Click to expand...

Hi Paul

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