Excel Conditional Sum Wizard Totals

[wbjc]

Operating System: Mac OS X 10.6 (Snow Leopard) Hi,

I've just loaded Excel onto my Mac and have been trying to do some conditional sums, however for some reason it will not allow me to display the totals on a separate sheet. It just keeps saving to the same sheet as the table, even when I select a cell on another sheet. Can someone please help advise how this is done? Or is this something that is not allowed?

Thanks

 

[CyberTaz]

What you 'want' shouldn't be a problem, although I'm not confident that I'm
certain what that is & it's rather difficult to determine why you're not
getting it... You haven't even mentioned what version of Office you're using
(there are at least 3-5 versions currently in use), what its update level is
or how you're going about trying to get it done - What is a "Conditional Sum
Wizard"... Are you using Excel 2004 by any chance?

If you've "just loaded" Office make sure you have also updated it fully,
repaired disk permissions & restarted. If the problem persists, please give
a complete & accurate description of your data, how it's arranged, what
results you want to obtain as well as what specific steps you've taken
toward that end & exactly how the result deviates from it. Include actual
cell & sheet references as well as whatever formulas you're using - it's
impossible to determine why something isn't working as expected if we don't
even know what it is We can't see your sheets from here.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[pjonesCET]

If you want just to show just on the second sheet try

while in a a cell on second sheet Type formula similar to:

sum of numbers in a Column:

=Sum(Sheet1!A1:A10) the *Sheet1!* tells Excel to use information from cells on a different sheet in the workbook.

I've just plugged information as example the sheet numbers used depends upon where your information is. and agin I just used A1:10 as a series in columm A.

Now if you just need certain parts of column it would be formatted A1+A10 or whatever.

more than one column =Sum(Sheet! A1+B1) or =Sum(Sheet1! A1:A10+B1:10) Ideal way would be sum the columns in the first down then do a sum desired column say =Sum(A1:A10) in cell A11, the repeat for column B in cell B11. the add A11 and B11 together (where ever) then just repeat the formula in the second sheet adding the Sheet1! in front.

NOw I hope I haven't got too complex. Sometime zi go off the deep-end.