| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIF with condition and exception
I need help with a SUMIF formula that is needed that adds the amount based on
one condition but excludes another. Example: A B C Prsn Type Contracts 1 JG MP $8000.00 2 JG DV $1200.00 3 JG MP $10000.00 4 SA AF $6000.00 5 SA DV $4500.00 4 JG AF $3000.00 5 JG DV $1500.00 I need it to calculate the total contract amount for all of JG's, except for the types marked as MP. Any help would be great. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif with a second condition | Excel Worksheet Functions | |||
| SumIF for more than one condition | Excel Worksheet Functions | |||
| sumif with or< condition | Excel Worksheet Functions | |||
| SUMIF with Exception of multiple Item | Excel Discussion (Misc queries) | |||
| sumif on more than one condition | Links and Linking in Excel | |||
![Scott A[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
