Greetings,
I am completely oblivious when it comes to creating and manipulating any kind
of coding or formatting in Calc so please be gentle.
It is my desire to create a small spread sheet that has 2 rows and 6 columns.
I'd like to have row 2, column 1 be a total from columns 3 and 5; I'd like to
have row 2, column 2 be a total from columns 4 and 6. Does that make sense?
Here's kinda how I'd like it to look:
Closed Totals | ##
Escalated Totals | ##
Online Closed | ##
Online Escalated | ##
Offline Closed | ##
Offline Escalated | ##
**Where the titles are in Row 1 in descending columns, the "|" indicates the
cell separation, and the "##" are in row 2 in descending columns next to the
titles.
The titles would be in row 1, columns 1 through 6 and the "##" would be in row
2, columns 1 through 6.
Now, the tricky part . . . is there a way to make it so I can click on the "##"
next to Online Closed, Online Escalated, Offline Closed, Offline Escalated and
have them go up 1 digit starting with 0?
Another example:
Online Closed 24 <----I would click on the cell with the number and it
would go up 1 point to 25 . . . or perhaps have some up/down arrows instead?
Ultimately, I'd like to have it so the totals from the Online and Offline
Closed categories would then give me a final tally in the top row, "Closed
Totals" in the "##" box next to that and the same for the "Escalated Totals."
I know this sounds like quite a bit but anyone's help would be greatly
appreciated. =)
