| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif with not criterion
I want to use the sumif criteria for cases where comments is not cancelled.
Can we use the sumif with the condition that comments is not equal to Cancelled. Item Inv Amt comments Stationery $12,332.00 Cancelled Machinery $24,324.00 In Process Training $23,141.00 Cancelled Misc Expense $34,223.00 Delivered |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sumif with not criterion
=SUMIF(C2:C5,"<Cancelled",B2:B5)
Regards, Stefi €˛Kiran€¯ ezt Ć*rta: I want to use the sumif criteria for cases where comments is not cancelled. Can we use the sumif with the condition that comments is not equal to Cancelled. Item Inv Amt comments Stationery $12,332.00 Cancelled Machinery $24,324.00 In Process Training $23,141.00 Cancelled Misc Expense $34,223.00 Delivered |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sumif with not criterion
Try
=SUMIF(C:C,"<Cancelled",B:B) If this post helps click Yes --------------- Jacob Skaria "Kiran" wrote: I want to use the sumif criteria for cases where comments is not cancelled. Can we use the sumif with the condition that comments is not equal to Cancelled. Item Inv Amt comments Stationery $12,332.00 Cancelled Machinery $24,324.00 In Process Training $23,141.00 Cancelled Misc Expense $34,223.00 Delivered |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF criterion to match the first 5 characters. | Excel Worksheet Functions | |||
| SUMIF Criterion with NOT | Excel Worksheet Functions | |||
| Multiple Criterion in a SUMIF function | Excel Worksheet Functions | |||
| IF(<criterion across sheets,1,0)? | Excel Worksheet Functions | |||
| How do I put more than one criterion in a SUMIF function? | Excel Worksheet Functions | |||
Linear Mode
