Barking_Mad
New Member
- Joined
- Jun 6, 2013
- Messages
- 20
Hi,
Not sure exactly what will work here, but I basically need the following:
Look up the value in F1 in A2:A4
If a match is found check:
IF the date in B2:B4 is => G1
AND the date in C2:C4 is <= H1
where both are true SUM the relevant values in column D (D2:D4)
I've attached a jpeg of what the outcomes should be to my dropbox as it might make it easier to understand
Not sure exactly what will work here, but I basically need the following:
Look up the value in F1 in A2:A4
If a match is found check:
IF the date in B2:B4 is => G1
AND the date in C2:C4 is <= H1
where both are true SUM the relevant values in column D (D2:D4)
I've attached a jpeg of what the outcomes should be to my dropbox as it might make it easier to understand