You mean that the huser is typing into this cell, but if they type an 'E' and
there are already 3 E's in the list, the user's entry should be changed to 0?

You can't do that with a formula. You would need to employ a worksheet_change
event. To help with that, we need mopre information about where the CountIf
range is.

On Thu, 5 Aug 2004 06:59:13 -0500, yorkeyite
wrote:

Wrong cell

I need the active cell ie the last cell in the countif range to have E
typed into it to default to 0 when the value of the countif function
exceedes 3


---
Message posted from http://www.ExcelForum.com/