SUMIFS Formula with Does Not Contain

I am creating a number of data sheets that will be the data for various Dashboard objects.

I have a master data file that lists all customers, Status, Pipeline $, etc. (Sales Pipeline Data Sheet)

In my current sheet, I am trying to enter a formula that will sum the total Pipeline $ for each Customer, along with the condition that the Status does not contain Invoiced.

The formula I currently have is:

=SUMIFS({Sales Pipeline Data Sheet - Range 1}, {Sales Pipeline Data Sheet - Range 2}, Customer@row, {Sales Pipeline Data Sheet - Range 3}, "<>*Invoiced*")

I am getting values returned, but it is including the total pipeline of each customer and NOT excluding those who have Invoiced included in the Status column (Range 3)



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!