Thread: SUMIF HELP
View Single Post
  #3   Report Post  
Jason Morin
 
Posts: n/a
Default

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

.