equation help.

  • Thread starter Thread starter julie
  • Start date Start date
J

julie

Please help. I need to employ a simple addition equation
into a cell. Problem: I'm using a form made in excel and
the original figure I need to add to is in one cell,
identified as 4 cells (AA,AB,AC,AD). I keep getting a
#name error. Can anyone help me??
 
Hi Julie!

You need row numbers to go with the columns:

eg:

=A1+A2+A3+A4

At present, with just letters, Excel is interpreting the references as
names and since the names don't exist it is saying #NAME?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top