Can I count how many grey-filled cells are in a row ?

A

AnthonyG

How can I return a value to a cell, that counts the number of grey filled
cells
in a particular row ?

ie I have rows of 12 cells, some with only 7 cells I need to count, so I
fill these cells grey.
However some filled cells have no value in them, but I still need to
count these cells for my total.
It's not the value in the cell I need, just whether or not it is
color-filled.

I'm not sure if this can be achieved.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check 3 cells, only one of the cells my be filled 7
count colored cells in excel 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Sum if cell = grey 4
Counting Blank Cells until end of Column 3
Mandatory cells only if another cell is filled 0
NA() and COUNTIF functions together? 1
Count no of nights between dates 4

Top