|
-
Mar 23rd, 2023, 12:53 PM
#1
[RESOLVED] Count colored cells in a filtered column
Column X in my worksheet is formatted as General and in that column some of the cells are blank, some are numbers, and some are numbers with a fill color, and all the fill colors are the same.
I need a formula that will return the count of the visible cells that have a fill color, even when the rows are filtered. For example if no rows are filtered and there are 4 filled cells the formula should return 4 and after filtering if there are only 2 visible filled cells the formula should return 2.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|