COUNTIF
 

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

Assuming the data is in col A, A1 down
Try in say, B1: =COUNTIF(A:A,"AA")*20%
Format B1 as percentage
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Natalie" wrote in message
...

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