Rip-N-Burn
New Member
- Joined
- Apr 27, 2005
- Messages
- 18
I have a relatively large workbook with several formul criterias.
This one works fine for only one criteria being hs01 and adds the amounts between 500 and 1000.
=SUMPRODUCT(($C$2:$C$6003="HS01")*($G$2:$G$6003>=500),($G$2:$G$6003<=1000)*$G$2:$G$6003)
My problem is when trying the same with a multi criteria. that being bb02,bb03 and so on.
=SUMPRODUCT(--(C2:C6003={"BB02","BB03","BB04","BB05","BB06","BB07","BB08","BB09","BB10"})--($G$2:$G$6003>=500)--(G2:G6003<=1000))
Any help would be very much appreciated.
Thanks
Kenny..
This one works fine for only one criteria being hs01 and adds the amounts between 500 and 1000.
=SUMPRODUCT(($C$2:$C$6003="HS01")*($G$2:$G$6003>=500),($G$2:$G$6003<=1000)*$G$2:$G$6003)
My problem is when trying the same with a multi criteria. that being bb02,bb03 and so on.
=SUMPRODUCT(--(C2:C6003={"BB02","BB03","BB04","BB05","BB06","BB07","BB08","BB09","BB10"})--($G$2:$G$6003>=500)--(G2:G6003<=1000))
Any help would be very much appreciated.
Thanks
Kenny..