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

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

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.
... Am using OFFICE PRO 2003.

Not sure what answer you expect, but here are valid formulas for a few
guesses:

=COUNTIF(F16:F703,"A")+SUM(G16:G703)-1

=COUNTIF(F16:F703,"A")+COUNTIF(G16:G703,"B")-1

=COUNTIF(F17:F704,"A")+MAX(G17:G704)-1

("G16:G703" isn't a number, so adding it to another number isn't
meaningful.)

.... or maybe
=COUNTIF(F17:G704,"A")-1
??

COUNTIF(F16:F703,"A")+G16:G703-1

Try this:

=SUMIF(F16:F703,"A",G16:G703)-1

--
Biff
Microsoft Excel MVP


"mcoge" wrote in message
...
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