=SUMPRODUCT(--(rng1="val1"),--(rng2="val2"),--(rng3="val3"),rng4)
will make 3 tests and add from rng4 where all 3 are met
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Peter Curtis" wrote in message
...
Any idea how you can enter three arguments into the SUMIF function?
Many thanks
|