How do I add cells using a LEN, Indirect formula?
On a table called "Checkpoint" I have inserted the formula shown below in cell C3. It's purpose is to copy a value from a set of other tables (Day 1 - Day 31). On one of the "Day" tables is a cell e3 that contains the number 3. Using the formula shown below C3 shows the value 3. I now want the sum of 2 cells inserted into the formula, where e3(3)+g3(4) will equal 7 in C3.
C3=IF(LEN(INDIRECT("Day "&COLUMN()−3&"::e3"))<1,"",INDIRECT("Day "&COLUMN()−3&"::e3"))
I need to add g3 this formula so that the output will give the sum of ::e3+::g3. Both Cells are located on the same table.
When I tried the formula shown below I got error "The operator "+" expects a number, date or duration but found"."
C3=IF(LEN(INDIRECT("Day "&COLUMN()−3&"::e3")+("Day "&COLUMN()−3&"::g3"))<1,"",INDIRECT("Day "&COLUMN()−3&"::e3")+("Day "&COLUMN()−3&"::g3"))
What am I doing wrong?
iMac (27-inch, Late 2012), OS X Mavericks (10.9.2)