countryfan_nt
Well-known Member
- Joined
- May 19, 2004
- Messages
- 758
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"))
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"))