Processing
 

Count number of cells with color fill Excel 2013

25/08/2016 07:20#1

em12

Member

Joined at: 7 months ago

Post: 3

Thank: 0

Thanked: 0

Is there a way/a function to count the number of color filled cells in Excel 2013 without using VBA? Something like

COUNTxxx(A1:A20) 
25/08/2016 08:20Top#2

Joined at: 4 months ago

Post: 3

Thank: 0

Thanked: 0

Pretty sure you have to use VBA

30/08/2016 09:00Top#3

Joined at: 4 months ago

Post: 1

Thank: 0

Thanked: 0

Unfortunately, it is not possible to fulfill this task using only the Excel built-in function(s).

There are 2 ways:

  1. Create one or several User Defined Functions using VBA that will count / sum colored cells and then call them from the workbook. You can also place these UDFs into the personal.xlsb file, then you don't need to copy them each time in a new workbook. However, it is not possible to correctly process cells colored with a conditional format using UDF.
  2. Use a special add-in that will count / sum the necessary cells based on their color.

You can find more details about the ways to count / sum colored cells, including the VBA code, in this blog post: How to count and sum cells by color in Excel

Similar articles

Excel More conditions in one formula?

4 months ago - Reply: 2 - Views: 171

Get Workbook reference from Open File dialog

4 months ago - Reply: 2 - Views: 128

Add Calculated Field To Pivot Table

4 months ago - Reply: 0 - Views: 5

Nested IF Functions in Excel not working

4 months ago - Reply: 3 - Views: 163

Formulating Date in Excel 2013

4 months ago - Reply: 2 - Views: 88

VB6 extracts in Excel 2013

5 months ago - Reply: 2 - Views: 153

Excel 2013 : Pull Matching Data from Column

5 months ago - Reply: 1 - Views: 19

excel search and copy in/from another file

5 months ago - Reply: 0 - Views: 1

Buggy PivotTable.ColumnRange

5 months ago - Reply: 0 - Views: 4

Excel static conditional formatting area

5 months ago - Reply: 0 - Views: 8

vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re