COUNTIF

N

Natalie

Hi there,

I am trying to count all the cells with AA in them, and for each occurance
record it as 20%. I am using a countif, but this is only counting each
occurance once.

I want the result to say

If it once 20%, twice 40% three times 60% etc, but at the moment it puts 20%
whether it is once, twice or three times?

Thanks
 
M

Max

Assuming the data is in col A, A1 down
Try in say, B1: =COUNTIF(A:A,"AA")*20%
Format B1 as percentage
 
Top