=SUMPRODUCT(--(A3:A44={"M","W"}),K3:K44)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Chance224" wrote in message
...
Can you have two arguments for a SUMIF function? I want cell K56 to sum
cells K3:K44 if cells A3:A44 has a value of M or W. I can it to work with
just one value but I'm unsure of how to get it to do two.
Thanks,
Chance
|