Hi,
I am working on a spread sheet but unable to come up with the formula... here is what I want from the formula.
Lets assume, in Col A; A to E are the various categories and in Col B, there is a score (0, 3, 6 & 9), In col C I need the average of Col B but if any of the score is "0" then the formula should not do the average but give "0" as a result. Attached file with some more details...
A
B
C
D
E