COUNTIF

[Guest]

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

 

[Max]

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