Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF COMBINATION?? | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |