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.
Please Login or Register to view this content.
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