Afraid I'm not really sure what's the current issue that you're facing. The
names of the 26 sheets sandwiched between x and y is immaterial, the names
don't figure in the formula. And that formula: =SUM(x:y!B2)
would simply add up the numbers in cell B2 in each sheet,
eg: 2 + 3 + (-3) + 4 + (-7) + ....
assuming that these are the numbers (could be positive or negative) that's
in cell B2 in the 26 sheets
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"MO" wrote:
Max,
The only problem is that the first tab is a negative number but the sandwich
is treating it like a positive number. Other tabs (in the future) may have
negative numbers. Is there a way to make this work with the sandwich method?
--
Thank you for your help
MO
Albany, NY