On Tue, 14 Mar 2006 08:19:26 -0800, Guybon Berry <Guybon
wrote:

I am completely confused.
H represents a staff member on Holiday.
I have a total number of staff and want H to represent -1.
If H is entered in any of the range of cells selected it must represent -1
and be able to be included in a formula.
Please help.

You might be able to incorporate a COUNTIF function in your formula:

=Staff_Numbers - COUNTIF(rng,"H")


--ron