SUMPRODUCT With OR function?

[countryfan_nt]

Hello friends,

The bolded part below is not working. I want to have the OR function
work. I tired several methods, but no use.
Thanks for your help.

Nawaf


=SUMPRODUCT(--(F4:F30>=DATE(2005,4,1)),--(F4:F30<=DATE(2005,4,20)),--(G4:G30="CENTRAL"))--(H4:H30=OR("AM","MA","MGR","SM","AGM"))

 

[barry houdini]

Try it like this

=SUMPRODUCT(--(F4:F30>=DATE(2005,4,1)),--(F4:F30<=DATE(2005,4,20)),--(G4:G30="CENTRAL"),--ISNUMBER(MATCH(H4:H30,{"AM","MA","MGR","SM","AGM"},0)))

 

[countryfan_nt]

Nice, very nice thank you very much.

All the best,
Nawaf

 

[mrnacar]

Thank you for this thread. This will come in handy.