Thread: SUMIF HELP
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
[email protected] sarasi.groups@gmail.com is offline
external usenet poster
 
Posts: 1
Default SUMIF HELP

On Tuesday, March 15, 2005 at 10:25:27 PM UTC+5:30, Bob Phillips wrote:
=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


=SUMIF(K3:K6,"0<")