I'm trying to count the number of X's in a column "C" if the color of the cell is not changed to another color. Can this be done through a function or do I need to do a VBA. I started with the formula
But I need to incorporate the cell color.
=SUMPRODUCT(LEN(C:C)-LEN(SUBSTITUTE(C:C,"C","")))
If you want to avoid VBA then you need to add filter.
Add filter, filter by color and filter X out then use SUBTOTAL to count the rest.
Never use Merged Cells in Excel
Not really what I'm trying, I need to count them with there being multiple words in cell beginning with x
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks