Counting coloured cells

Yusuf

Active Member
Joined
Jun 1, 2004
Messages
337
Hi all
Is counting cells that have been filled by a particular colour possible at all?
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

parry

MrExcel MVP
Joined
Aug 20, 2002
Messages
3,355
Not with the functions that come standard with Excel but I have created an add-in that gives you format functions which will enable you to count cells of different colours. Its free and downloadable from http://www.vbaexpress.com/cooltools.php
 

Watch MrExcel Video

Forum statistics

Threads
1,118,823
Messages
5,574,523
Members
412,601
Latest member
TheBeaniacExpress
Top