View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yerman Yerman is offline
external usenet poster
 
Posts: 1
Default 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.