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

I think Bob meant this:

=3DSUMPRODUCT((A3:A44=3D{"M","W"})*K3:K44)

Jason

-----Original Message-----
"Bob Phillips" wrote
=3DSUMPRODUCT(--(A3:A44=3D{"M","W"}),K3:K44)


Tried this, Bob, but think it returns #VALUE!

--
Rgds
Max
xl 97
---
GMT+8, 1=B0 22' N 103=B0 45' E
xdemechanik <atyahoo<dotcom
----


.