I'm using the following info as part of my spreadsheet.
A B C D E F
1 LA LS LU LT Sessions Month
2 LU 1.5 NOV
3 LA 3 DEC
4 LT 4 NOV
5 LA 2.1 NOV
LS JAN
I need a formula which will calculate the sum of sessions with the conditions that i need to select a month and a code. i'm using Excel 2007 and the following formula worked ok:
=SUMIFS($E$1:$E$4,$F$1:$F$4,"Nov",$A$1:$A$4,"LA").
However, i need to send it to someone using the 2003 version of Excel, which does not have the function SUMIFS. i think the formula i need is the SUMPRODUCT one but i cant get it to work.
Can anyone help please?
A B C D E F
1 LA LS LU LT Sessions Month
2 LU 1.5 NOV
3 LA 3 DEC
4 LT 4 NOV
5 LA 2.1 NOV
LS JAN
I need a formula which will calculate the sum of sessions with the conditions that i need to select a month and a code. i'm using Excel 2007 and the following formula worked ok:
=SUMIFS($E$1:$E$4,$F$1:$F$4,"Nov",$A$1:$A$4,"LA").
However, i need to send it to someone using the 2003 version of Excel, which does not have the function SUMIFS. i think the formula i need is the SUMPRODUCT one but i cant get it to work.
Can anyone help please?