using sumproduct in place of sumif

[lilolme]

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?

 

[Jonmo1]

Yep, sumproduct would work...

=SUMPRODUCT(--($F$1:$F$4="Nov"),--($A$1:$A$4="LA"),$E$1:$E$4)

 

[barry houdini]

You can use this syntax

=SUMPRODUCT($E$1:$E$4,($F$1:$F$4="Nov")*($A$1:$A$4="LA"))

 

[lilolme]

thank you thank you both, it worked perfectly!!