| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumIf - when I fill down the Range, Criteria & sum range changes | Excel Worksheet Functions | |||
| match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
| sumif when criteria is a range | Excel Discussion (Misc queries) | |||
| SUMIF with AND for range and criteria | Excel Worksheet Functions | |||
| SUMIF multiple criteria in 1 range | Excel Worksheet Functions | |||
Threaded Mode
