got it to work thanks.

Peo Sjoblom wrote:
Did you try any of the formulas, all the formulas I posted work if you want
to count
cells that are not empty with formulas in them.

COUNTIF(A1:A100,"?")

will not include cells with formulas that returns ""
and will only count if the result is text

I dont think that I have explained it correctly
I have multiple work sheets. On worksheet A I have a chart where someone
[quoted text clipped - 27 lines]

Can I get help on how to make it so it ignores the cells with a formula

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1