MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sumif with multiple criteria


Posted by George Inman on March 08, 2000 7:06 AM

Normal
sumif(a1:a100,a101,b1:b100)
Desire
sumif(and((a1:a100,a101),(c1:c100,c101)),b1:b100)


Posted by bill.roberts on March 08, 2000 7:19 AM

Posted by Jaime on March 08, 2000 7:37 AM

Hi,
Forget about the sumif function. Use something called boolean logic. For example this one might help u. It just like ur function is working with three columns each with 100 numbers. The decision criteria is in the 101 row. This is an array function. This means that when u enter it u press ctrl+shift+enter, not just enter.
This one for emample just sums all the values greater than the number in row 101 for each column


=SUM(A1:A100*(A1:A100>A101),B1:B100*(B1:B100>B101),C1:C100*(C1:C5>C100))

If u need any help just say