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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do you count (not sum) cells containing special formatting? (https://www.excelbanter.com/excel-worksheet-functions/50123-how-do-you-count-not-sum-cells-containing-special-formatting.html)

tbank

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

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

Richard Buttrey

On Wed, 12 Oct 2005 12:52:03 -0700, "tbank"
wrote:

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

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

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

All times are GMT +1. The time now is 09:53 PM.