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?