I need to get excel to recognize two different values in two different column but unable to do so. So i was "forced to" put the value in one single column and used the formula below
formula used
=SUMPRODUCT(((October!$C$3:$CQ$3=$G$1)+(October!$C$3:$CQ$3=$H$1))*(((October!$B$7:$B$69)=$A4)*((October!$C$7:$CQ$69="D 12hrs"))))
To get the formula to count, i have to input my data under Column F
Column F Column G
D 12hrs
I tried to add in more criteria to the formula but it generate a zero value
Anyone can advise?
Thank you
formula used
=SUMPRODUCT(((October!$C$3:$CQ$3=$G$1)+(October!$C$3:$CQ$3=$H$1))*(((October!$B$7:$B$69)=$A4)*((October!$C$7:$CQ$69="D 12hrs"))))
To get the formula to count, i have to input my data under Column F
Column F Column G
D 12hrs
I tried to add in more criteria to the formula but it generate a zero value
Anyone can advise?
Thank you