hi all. i have been working on a very involved spreadsheet in numbers and have been receiving some absolutely mission critical help from posters on the forum kind enough to answer my questions (thank you!).
i am really desperate to finish this spreadsheet as i am way past my deadline for this and am finding the need to triage without losing too much work. some help please if possible:
1. is it possible to /exclude/ a COLUMN of cells from a SUM calculation that i am totalling up on the right, without deleting the whole ROW? what i mean is that i have set up a calculation in each ROW to add a percentage to from another COLUMN that is independent from this SUM but i want to simply remove this COLUMN with the added percentage from the horizontal SUM.
A. Can I MOVE this column off to the right and have it excluded from the SUM or will it still be included in the SUM since it was included originally?
B. is there a way to simply turn /off/ the COLUMN in a manner that will exclude it? i tried hiding it but even if it is hidden i am seeing that it is still included in the calculation...
2. how does the SUM function work in terms of /adding/ ROWS/COLUMNS? if i add a row or column between rows or columns that are being summed it seems that these will get added to the cells being summed. however, is it the case that if i add this row or column in /front/ of these cells or at the end of these cells (say just in front of the sum cell) that these are not included?
i realize i can test this but i am up against a deadline and getting very close to finishing so any pro-level help on this kind of macro explanation would be really welcome.