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!
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
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