SUMIF invoice totals from the past 6 months

Megan Pecunia

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. 

 

 

KrisWalsh

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?

 

Megan Pecunia

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?

Travis

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. 

Megan Pecunia

Perfect.

Thank you!