VALUE ERROR RETURNED FROM FORMULA
 

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

VALUE ERROR RETURNED FROM FORMULA
 

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

VALUE ERROR RETURNED FROM FORMULA
 

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

VALUE ERROR RETURNED FROM FORMULA
 

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

VALUE ERROR RETURNED FROM FORMULA
 

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