=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