got a #NAME? response from excel
that is how I set the formula, but when I hit 'enter', the formula changes to
include another Dec 2012 like so: =sum(Dec 2012!)'Dec 2012'l5:l8 and then asks me which worksheet to use, and then when I select worksheet
and hit enter, up pops the #NAME?
file id is 917718
in Jan 2013, cell L5, I am trying to put total of Dec 2012, L5:L8
Thanks for your help.....I don't understand why the last formula you wrote has a space where the ! was before....can you explain?