sumif using multiple criteria and its own range
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.
|