Thread: SUMIF HELP
View Single Post
  #7   Report Post  
John Britto
 
Posts: n/a
Default

Kindly use the formula in the following manner.

=SUMIF(A3:A6,"m",K3:K6)+SUMIF(A3:A6,"w",K3:K6)+SUM IF(A3:A6,"j",K3:K6)

Good luck..john britto

"Chance224" wrote:

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 Im unsure of how to get it to do two.

Thanks,
Chance