Thread: SUMIF HELP
View Single Post
  #5   Report Post  
Max
 
Posts: n/a
Default

"Bob Phillips" wrote
=SUMPRODUCT(--(A3:A44={"M","W"}),K3:K44)


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

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