G
Guest
Can anyone show me how to convert this formula to count cells rather than sum them
=SUMPRODUCT(--(MONTH($O$11:$BN$11)=MONTH(DM$11)),$O19:$BN19
I tried adding "counta" to the beginning, then to the last section but it didn't work
The formula is looking up columns with a month the same as DM$11 and summing the numbers within those corresponding cells - I need it to count the active cells rather than sum them
Any help is much appreciated.
=SUMPRODUCT(--(MONTH($O$11:$BN$11)=MONTH(DM$11)),$O19:$BN19
I tried adding "counta" to the beginning, then to the last section but it didn't work
The formula is looking up columns with a month the same as DM$11 and summing the numbers within those corresponding cells - I need it to count the active cells rather than sum them
Any help is much appreciated.