Sumif with not criterion

  • Thread starter Thread starter Kiran
  • Start date Start date
K

Kiran

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF using 2 cells that equal each other 1
Sumif(or 3
Where to put quotes in a SUMIF formula and when is & used for cell 2
Conditional formatting w/ a sumif 1
sumifs problem 1
How to Count the number of "rows" (or Array items) included in a Sumif formula? 3
SUMIF-how do i get it to work using names in range?help 3
Criteria Syntax in SUMIF formula 4

Back
Top