Weird Named Range Error

users
#1

Hello,

I'm wondering if someone can please take a look at the attached sheet.
Specifically, columns B and C. Note that the named range
"ExpensesPlanned" is B9-B42; "ExpensesActual" is C9-C42. On line 45,
there are totals for the named ranges. However, for some reason, any
numbers entered into lines 35-42 do not get added into those totals.
Can anyone determine why?

(Note that there is a macro: it's a Python script that will calculate
the week ending dates for all biweekly pay periods and create
corresponding worksheets.)

Thanks!
-JK

#2

I'm wondering if someone can please take a look at the attached sheet.

No! Attached files are generally removed by the mailing list processor before messages are distributed. So no-one will have seen your document or be able to see what you mean.

[...] On line 45, there are totals for the named ranges. However, for some reason, any numbers entered into lines 35-42 do not get added into those totals. Can anyone determine why?

One obvious guess is that the relevant cells have been formatted as Text before the values were entered or that values that might have been pasted in were themselves text, not numbers. Text values are treated as zero in numerical formulae, so will be ignored in your totals.

Numbers are right-aligned by default, whereas text values are left-aligned, but you may have hidden this distinction by setting the cell alignment explicitly.

Note that you can use View | Value Highlighting (probably temporarily) to display the difference: numerical values appear in blue whereas textual values appear in black (and results of formulae in green).

I trust this helps.

Brian Barker