ENET01 FG5178 2-Mar-05 50
ENET01 FG5178 5-Mar-05 80
EEUR00 FE7262P 25-Mar-05 128
ENET01 FE4137 25-Apr-05 120
ENET01 FE4138 25-Apr-05 360
ENET01 FE8138P 25-Jun-05 80
ENET01 FE9136 25-Jul-05 30
EJTS02 FT1007 25-Sep-05 1080
EPI100 FG7001WO 25-Nov-05 40
I have a problem but its too big to explain. So I will make up this smaller problem and see if anyone can help me
Above is some data from Sheet2.
Sheet one has three fields with the following data:
ENET01
FG5178
10-Mar-05
I want to sum the integers Where The data is ENET01, FG5178 AND the date is less than 10-mar-05. So in the data above the answer would be 130.
HOW to do this? I can do it without the Less than 10-mar-05 bit, but im stuck with it.
GmcB
Bookmarks