How do i count the number of conditional formatted cells?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to count the frequency of a number in a series of numbers possibly
using a count if or lookup function. I wish the total number to be displayed
at the bottom, how can i do this?
 
Kate

Your subject line reads "count the number of conditional formatted cells".

You would need VBA to count CF cells.

http://www.cpearson.com/excel/CFColors.htm

If the subject was not correct, you could use the FREQUENCY Function to return
the frequency of numbers in a range.

Or COUNTIF to return the total number of times a number apears in a range.

=COUNTIF(A1:A100,34) where 34 is the number.

Maybe more detail will give a clearer picture of your needs?


Gord Dibben Excel MVP
 
Look in help for COUNTIF and FREQUENCY, help explains both formulas well


Regards,

Peo Sjoblom
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Counting number of items excluding duplicates. 1
count until blank cell 2
Counting number of instances a conditional format is met in a colu 3
Matching records based on a common field 1
description of count in subtotal 1
How do I count the number of each number in a column? 5
Excel Conditional Formatting 1

Back
Top