VALUE ERROR RETURNED FROM FORMULA

[mcoge]

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

 

[Sheeloo]

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.

 

[MyVeryOwnSelf]

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.)

 

[MyVeryOwnSelf]

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

 

[T. Valko]

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

Try this:

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