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

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNTIF COMBINATION?? Heather Excel Worksheet Functions 1 April 26th 05 02:44 AM
Combining IF and COUNTIF based on two columns maxtrixx Excel Discussion (Misc queries) 5 March 31st 05 06:21 PM
COUNTIF in one colum then COUNTIF in another...??? JonnieP Excel Worksheet Functions 3 February 22nd 05 02:55 PM
Countif - Countif maswinney Excel Worksheet Functions 3 November 15th 04 11:06 PM
countif, again Liz G Excel Worksheet Functions 2 November 1st 04 11:20 PM


All times are GMT +1. The time now is 11:51 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017