Remember Me?

#1
May 23rd 05, 12:09 PM
 Natalie Posts: n/a
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
May 23rd 05, 12:16 PM
 Max Posts: n/a

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Heather Excel Worksheet Functions 1 April 26th 05 02:44 AM maxtrixx Excel Discussion (Misc queries) 5 March 31st 05 06:21 PM JonnieP Excel Worksheet Functions 3 February 22nd 05 03:55 PM maswinney Excel Worksheet Functions 3 November 16th 04 12:06 AM Liz G Excel Worksheet Functions 2 November 2nd 04 12:20 AM

All times are GMT +1. The time now is 07:55 AM.