Quote:
Originally Posted by SJRockower
I would have thought this was easy but I can't find the answer. How to I construct a formula to add across sheets, ie =sum(Sheet2!A1+Sheet3!A1+Sheet4!A1) is the easy way but that gets tedious if there are more than a few sheets. will =sum(Sheet2:Sheet4!A1) work?
Thanks
|
I found my answer. Yes, that formula will work.