They are black as the result of another formula
but I want to give a count in a summary page.

Use the logic of *why* the cells are black to build a formula to count them.

You say they're black as the result of another formula....so what is the
result of that other formula that causes the cells to turn black? Base your
count on that logic.

For example, the cells turn black when they contain a number greater than
100. Then:

=COUNTIF(A1:A10,"100")

--
Biff
Microsoft Excel MVP


"Denise" wrote in message
...
How can I use the color of a cell in a formula? I need to tally all the
cells
in one column that are black. They are black as the result of another
formula
but I want to give a count in a summary page. Thanks in advance!