You want to use the total of the values in G16:G703?
If yes, then use
=COUNTIF(F16:F703,"A")+SUM(G16:G703)-1

If not then let us know what you want to calculate.
--
--------
If this is what you wanted then press the ''''YES'''' button (if you see it)


"mcoge" wrote:

The formula COUNTIF(F16:F703,"A")+G16-1 works properly, But when I change the
formula to COUNTIF(F16:F703,"A")+G16:G703-1 returns a #VALUE# error.
No matter what I do I cannot get it to work right. Need help asap working on
a program for the hospital. Am using OFFICE PRO 2003.

Waiting for an answer with many thanks