| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIFS with an OR criteria
I currently have the formula:
=SUMIFS('Labor Reclasses'!$D$6:$D$8000,'Labor Reclasses'!$M$6:$M$8000,Summary!$A4,'Labor Reclasses'!$F$6:$F$8000,"Travel-Non-Dispatch",'Labor Reclasses'!$F$6:$F$8000,"Travel")) I want to change the last two criteria to an OR. Thus the value in column D would be added for all cases where Column M matches Summary!A4, and Column F is either "Travel-Non-Dispatch" or "Travel" Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using sumifs with multiple criteria? | Excel Discussion (Misc queries) | |||
| sumifs criteria | Excel Worksheet Functions | |||
| SUMIFS with 3 criteria instead of just 2 | Excel Worksheet Functions | |||
| using sumifs to sum based on month, and criteria | Excel Worksheet Functions | |||
| Using wildcards in criteria for sumifs functions | Excel Discussion (Misc queries) | |||
![Go Bucks!!![_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
