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))
Hello...I'm hoping someone can help me here before my laptop goes for a flying lesson!
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))
Brilliant...works perfectly. Thank you very much NBVC
Bookmarks