Counting in Excel spreadsheets

  Newuser3477 21:25 22 Feb 10
Locked

Is it possible to count the number of cells coloured blue in a column containing only blue colour filled cells and blank ( no fill ) cells. If so please advise me of count formula
Thanks

  fsbb 22:54 22 Feb 10

Formula for counting blank cells is as follows (in this sample cell range is A1:A10)
=COUNTBLANK(A1:A10)

Colour in a cell is a format and those cells are blank unless an entry, number or text, is inserted.

  VoG II 09:32 23 Feb 10
  Newuser3477 09:47 23 Feb 10

Thanks for answers I can now do the counting I need

This thread is now locked and can not be replied to.

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…