Add column F as a hidden column and put the following formula in each row of
column F:

=IF(AND(A1="Sue", B1=4, C1="Y"), "Y", "N")

Then do a normal SUMIF formula in another cell, as follows:

=SUMIF(F1:F5, "Y", E1:E5)

Make sure that there are no trailing spaces after your names or "Y"/"N" or
the column F formulas won't work. I realize this is not exactly what you
were after, however, it should be a convenient enough work around.


"Mark Allen" wrote:

I have a range a cells as below:

A B C D E
Sue 1 N Jan-07 20,000
Jo 3 N Feb-07 10,000
Peter 4 Y Jan-07 30,000
Sue 5 Y Jan-07 20,000
Sue 7 Y Jan-07 10,000

I want to calculate total value of E when A=Sue, B=4, C=Y and
D=Jan-07...therefore the answer being 30,000

PLEASE HELP !!!!!! Its so frustrating when you are trying to learn......