Sumif

Hi,

I am trying to get the sumif function to work for me and I am having trouble. I am trying to count the dollar amount of invoices in column Invoice Amount if the the JOB# column has "BO" in it.

These are the formulas I have tried so far:

=SUMIF([JOB#]:[JOB#], IF(FIND("BO", [JOB#]:[JOB#]), [Invoice Amount]:[Invoice Amount]))

=SUMIFS([Invoice Amount]:[Invoice Amount], AND(FIND("BO", [JOB#]:[JOB#], @cell)), [Invoice Amount]:[Invoice Amount]))

=SUMIFS([Invoice Amount]:[Invoice Amount], AND(FIND("BO", [JOB#]:[JOB#], @cell)),[JOB#]:[JOB#] ))

=SUMIF([JOB#]:[JOB#], FIND("BO", [JOB#]:[JOB#]), [Invoice Amount]:[Invoice Amount]))

The first one returns 0 and the rest #unparseable. I should be getting $1000

Attached are the columns I need to use, and they are on the same page as my calculations.

Find more posts tagged with

Formulas

Comments

Kyle Lewis

Forgot to add that I will have other job#s that start with different characters which is why I need to isolate certain jobs against the correct invoice amount.

Mike Wilday

This should work for you...

=SUMIF([Job #]:[Job #], Find("BO", @cell) > 0, [Invoice Amount]:[Invoice Amount])

You were missing the criteria of > 0.

Let me know if it works!

Kyle Lewis

That worked!

Thanks!

Sign in to join the conversation!

Quick Links

Trending discussions

How to split contents from a cell from a smartsheet into another smartsheet
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.
Information in a form populates specific cell.
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…
A multiple SUMIF function
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])