sumif using multiple criteria and its own range
On Dec 28, 4:23*pm, Yerman wrote:
Using Excel 2003 trying to find a way of adding numbers in a row that match a
month and are less than 100. Ican Sumif matching the month but need to just
add together those above or below 100. So far i have
=SUMIF('Out and About'!B4:Y4:'Out and About'!B27:Y27,"January",'Out and
About'!B11:Y11:'Out and About'!B34:Y34)
but need the next part.
I'm not sure which range is which from your formula but, in general,
you can use SUMPRODUCT to get a sum with more than one criteria, i.e.
=SUMPRODUCT(--(date_range="January"),--(sum_range<100),sum_range)
I'm assuming that date_range contains just the month as text, not a
date
|