Count coloured cells

**laly** · 11-01-2009, 05:29 PM

Hi,

Please see the attached file

Can anybody tell me how to count coloured cells in excel,

For example, I have numbers with red , I want to count

how many Red coloured cells are in each line.

thanks

**darkyam** · 11-01-2009, 05:58 PM

=sumproduct(--(a2:q2=$w$2:$w$16))

**DonkeyOte** · 11-01-2009, 06:09 PM

If you wish to count all in one calculation

=SUMPRODUCT(COUNTIF($A$2:$Q$101,$W$2:$W$16))

**laly** · 11-01-2009, 06:10 PM

Originally Posted by darkyam

=sumproduct(--(a2:q2=$w$2:$w$16))

Thank's , you are the best ......

Count coloured cells

LinkBack

Thread Tools

Rate This Thread

Display

Count coloured cells

Re: Count coloured cells

Re: Count coloured cells

Re: Count coloured cells

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions