SUMIF formula if another field falls between a date range

[benchris]

What I am trying to do is find total dollars sold by a certain value, but the date value of another field has to be less then or equal to a date.

I have a table where a sumif is working pulling in the sum of certain values:

The formula is: =SUMIF(H:H,Z7,P:P)
H:H = the column that has all of the item group's
Z7 = item group number
P:P is the column of the value to be returned

There is also another field that shows the date the transaction took place. I am looking to create a formula that would state if the date range is less than or equal to <this field>, then the sumif statement would give back the results where the date column is equal or less than the date in the field.

For example

Col A Col B Col C
Date Item Group Value
02/04/2016 115 $1999
02/23/2015 116 $100
01/31/2016 115 $500

Field AA7 =SUMIF(B:B,Z7,C:C) and Z7 has value 115 in it and it would return $2449
Field AA8 = =SUMIF(B:B,Z8,C:C) and Z8 has value 116 in it and it would return $100

What I am trying to figure out is how to have a static date field and then a formula that would say that if the date is "<=" than the date stated in field Z10 then include the results from that row in the results.

Does this make sense? Any ideas on how I can accomplish this?

I appreciate the help. I have been reading here a lot, but finally registered today.

Thanks
Ben

 

[benchris]

ok. I will take a look closer. Appreciate the input!

 

[benchris]

Ford,

Thanks for the help! I am good to go.

Ben

 

[FDibbins]

awesome, thanks for the feedback