Blind Spot in my Excel Formula Abilities
December 23, 2009 6:32 AM Subscribe
Excel Idiot Filter: Is there some simpler way to calculate the averages of the same cell along multiple worksheets?
posted by itsonreserve to technology (7 answers total) 1 user marked this as a favorite
For example, say I'd like to take the total box on every previous worksheet and average it on a final worksheet. It's the same box on every single one, but I can't seem to get it to work. I've tried letting Excel write the formula for me, but after all that clicking it says the formula doesn't work. Can the worksheets be ranged? For example Say I have =AVERAGE('Sep 09 Wk 2'!H20,'Sep 09 Wk 3'!H20,'Sep 09 Wk 4'!H20). Can I write =AVERAGE('Sep 09 Wk 2':'Sep 09 Wk 4'!H20)? Also is there a limit on the number of things you can have in the formula, which could be causing Excel to not understand it, even when I try writing it using clicks?