sumifs dependent on data range within cells

Flappypaps

New member
Joined
Feb 19, 2015
Messages
2
Reaction score
0
Points
0
Hello...I'm hoping someone can help me here before my laptop goes for a flying lesson! :confused:

I need to insert an IF function at the start of the below formula so that the SUMIF only returns the sum when the date in 'Test Data'!$J:$J is between 01/02/2015 and 28/02/15

=SUMIFS('Test Data'!$I:$I,'Test Data'!$L:$L,"<=0",'Test Data'!$D:$D,C$8)

The trouble I seem to be having is that there is an existing VLOOKUP in 'Test Data'!$J:$J as the date is pulled from another workbook.

Any ideas?

Thanks
 
Try:

=SUMIFS('Test Data'!$I:$I,'Test Data'!$L:$L,"<=0",'Test Data'!$D:$D,C$8,'Test Data'!$J:$J,">="&DATE(2015,2,1),'Test Data'!$J:$J,"<="&DATE(2015,2,28))
 
Back
Top