I am using this formula to deduct for sick time, "=COUNTIF(K17:AL18,"S")*8"
and it works well. I need to add that if the TOTAL Cell (n44) is less than
one an error must flash to prevent the formula from entering a negative
amount.

Thanks for any suggestions you may offer.

Frank

Need help interpreting your post: you need to add sick time if the
total cell is less than one?

Dave,

I need to stop the formula from deducting 8 hours from the sick time total
if the person does not have enough sick time balance. I would like to triger
a message stating that the person does not have enough sick time to complete.

"Dave O" wrote:

Need help interpreting your post: you need to add sick time if the
total cell is less than one?

What formula do you have in N44?

How is the return of your Countif formula deducted?

The Countif() accumulates the "sick time" for a particular time period, but
you haven't told us what formulas you have in other cells that perform
calculations with *that* Countif() return.

It's *those* formulas that could be put in a validation setting that can,
for example, turn red when they reach a pre-arranged criteria.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Frank" wrote in message
...
Dave,

I need to stop the formula from deducting 8 hours from the sick time total
if the person does not have enough sick time balance. I would like to
triger
a message stating that the person does not have enough sick time to
complete.

"Dave O" wrote:

Need help interpreting your post: you need to add sick time if the
total cell is less than one?