SUMIF on multiple conditions.

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

Try...

=SUMPRODUCT(--(Sheet2!A1:A9=A1),--(Sheet2!B1:B9=B1),--(Sheet2!C1:C9<C1),Sheet2!D1:D9)

...where A1 contains your first criterion, B1, your second, and C1 your third.

Hope this helps!

Well here is the formula changed to fit my scenario. But I only get errors off it

=SUMPRODUCT(--('Navision Data'!F:F=B3),--('Navision Data'!G:G=A11),--('Navision Data'!I:I<D10),'Navision Data'!J:J)

SUMPRODUCT doesn't accept whole column references. But you can use a 'near' whole column reference...

=SUMPRODUCT(--('Navision Data'!F2:F65536.........)

Hope this helps!

Thank you very much i will try this!