ExcelBanter - Sumif with not criterion

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sumif with not criterion (https://www.excelbanter.com/excel-discussion-misc-queries/236903-sumif-not-criterion.html)

kiran

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

Stefi

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

Jacob Skaria

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

All times are GMT +1. The time now is 05:41 AM.