help needed with #value error

[TamaraH]

Hi.

I am trying to tote up Incidences of Use in a stats spreadsheet but keep getting the #VALUE! error.

The cells in question follow =F79+F113+F117+F124+F167+F176+F180+F184+F190+F220+F232+F238+F242+F248

The content of cells indicated in table below

Title of cell Row number Notes
S & V Archive Copy requests F79 =ASTELL!E7
Total Staff on TV/Radio F113 =F111+F112
Total Records on TV/Radio F117 =F115+F116
Searchroom visits total F124 =SUM(F119:F123)
Email + Postal enquiries total F167 =F166+F165
Telephone enquiries total F176 =SUM(F172:F175)
Reproduction enquiries F180 =BUTLER!E96
ERO Website hits F184 =BUTLER!E100
Genealogical Search orders F190 =WIFFEN!E17
External photo copy orders F220 =WIFFEN!E44
Photography External orders F232 =WIFFEN!E52
Microfilm External orders F238 =WIFFEN!E58
Microfiche External orders F242 =WIFFEN!E62
Digital Scan External orders F248 =WIFFEN!E67

I have checked the format of each cell in all worksheets. (ASTELL, BUTLER and WIFFEN are all in the same wookbook). All are formatted to Number, 1 decimal place.

Is there some reason why cells populated with data from another worksheet do not operate in formula?

 

[Andrew Poulsom]

wELCOME TO THE bOARD.

You have a text entry somewhere. Formatting only changes the appearance of a cell, not what it contains. You can use the ISNUMBER function to check that a cell really contains a number. Also the SUM function ignores text so you can use:

=SUM(F79,F113,F117,F124,F167,F176,F180,F184,F190,F220,F232,F238,F242,F248)

 

[TamaraH]

Oh my! That was fast. Works a treat. I am numerically challenged so EXCEL is a boon. I am self taught user and I just love all the bells and whistles.

Thanks very much Andrew.