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