 Ask
The Technology Therapist...
Do your numbers add up right?
If you find this tip helpful:
" Excel ", how many of us really
know how to use it? As many readers might smile to
themselves and say; “enough to get by.”
Although that may be true, if you knew more about some of
the functions that help you calculate, would you double
check your formulas?
Over the past month I have been asked about
this issue several times; adding up subtotals. If you create
a spreadsheet that has groupings of numbers you may find
that you want category subtotals and a grand total. But
when you create your sheet you may find that it is not very
simple. Have you tried using the subtotal formula as apposed
to the sum total formula?
By using the subtotal formula ,
you can create subtotals and grand totals , that do not add
in the subtotals. Click here to download sample spreadsheet
or view the pdf.
This is Jennifer Shaheen The Technology
Therapist with your technology tip of the week.
If you find this tip helpful:
|
