Using SUMPRODUCT offers the most flexibility, but in this=20
case you could use:
=3DSUM(SUMIF(A3:A44,{"M","W"},K3:K44))
HTH
Jason
Atlanta, GA
-----Original Message-----
Can you have two arguments for a SUMIF function? I want=20
cell K56 to sum=20
cells K3:K44 if cells A3:A44 has a value of M or W. I=20
can it to work with=20
just one value but I=E2?Tm unsure of how to get it to do=20
two.
Thanks,
Chance
.
|