How do you count (not sum) cells containing special formatting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you count (not sum) cells containing special or conditional formatting?
 
How do you count (not sum) cells containing special or conditional formatting?
Click to expand...

Can you not test for the conditional value which sets the conditional
format in a SUMIF() ?

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
You must log in or register to reply here.

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

Complex conditional summing - array COUNT works, array SUM gives#VALUE 4
Count and Sum of cells if conditions fulfilled 12
nth row or column counting 1
copying conditon formats with $ 12
Function for summing or counting cells based on a specified fill color 2
Time Sum in Excel 1
Excel formula, sum the value cell and if empty cell left blank 0
Excel Sum numbers in cells that also contain text 34

Back
Top