#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# SUMIF invoice totals from the past 6 months

Options
edited 12/09/19

Hi-

I have a sheet that I input invoice amounts into for multiple outside contractors. I have the name of each contractor as a parent row and their invoices as the children rows. The columns are date, invoice number, billable items, amount and code name.

I want to create a formula above all parent rows that would SUMIF the "Parent Row" and the "Date" met the criteria. I cannot find a way to make the parent row as a criteria or the date criteria to be the past 6 months.

Tags:

• ✭✭✭✭✭
Options

Example Sheet

Here's a work-a-round. Create a new column "Amount Last 6 mo".

On all the children rows put this formula.

=IF(NETDAYS(\$Date3, TODAY()) < 180, \$Amount3, "")

On all the parent rows put this formula.

=SUM(CHILDREN())

Does this accomplish what you're looking for?

• Options

Thanks Kris-

I tried the formula, but modified for my data. =IF(NETDAYS(\$Invoice Date2, TODAY()) < 180, \$Amount2, "")

It is coming back as #UNPARSEABLE.

Any idea why?

• Employee
edited 02/22/16
Options

Try this:

=IF(NETDAYS(\$[Invoice Date]2, TODAY()) < 180, \$Amount2, "")

If your column name contains spaces or numbers at the end, you need to use brackets.

• edited 02/22/16
Options

Perfect.

Thank you!

This discussion has been closed.