calculating nonblank cells with conditions

D

DB

I used check marks in a spreadsheet. Some of the cells have a pattern
(yellow) to as an identifier. I need to be able to count the number of cells
that have the yellow pattern. I used the formula =COUNTA(RANGE) which adds
all the nonblank cells in the column, but now I need to isolate the cells in
the specific row that have the yellow pattern.

Please advise.

Thank you.
 
D

DoctorG

If you write VBA code you can check the activecell.interior.color property.
First I guess you should retrieve this value from one of the cells that are
"yellow" in order to find out which number represents it and then test the
other cells against this value.

I don't know if there is a way to test directly in a worksheet cell with a
function, or if it is acceptable for the user to run a command with i.e. a
button in order to count them. Maybe someone else can help more.
 

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

Top