Hi,
I don't use Excel 2010, but I am hoping that the following idea will help.
1. Insert a new column next to the amount field
2. Fill the entire column with zeroes from the first to the last cell
that you are using
3. Where there is am amount for Wal-Mart, copy it to the new column
4. Do a sum of that column
I know that this idea will be tedious at first, but once it is set
up, the rest will be easy. You can hide that column so not to get in
the way of your register.
I created a macro using the keystroke CTRL+M (you can use any
keystroke you want) to copy an amount to a hidden column. I have a
total at the bottom of the column using (equal)sum and I don't have
to unhide the column to calculate the total. Of course, as you add
more rows, you may want to fill the other row (not Wal-Mart) with
zeroes as you move along. You can use the CTRL+M macro (assuming you
create one) to copy zeroes to the hidden column before you post an
amount in the register.
I hope that this will help. I don't know how you will create the
macro in 2010, but look at the Excel help and maybe you can figure
that out or someone on the list can help you.
Take care.
Lennie
At 02:17 PM 7/30/2011, you wrote:
Hi All,
I have our check register in Excel. If I would like to know how much we
spent at Wal Mart this year. Is there a formula or some other way we could
total these entries in steading of sorting and then totaling them? Using
jaws 12 and Excel 2010. Thanks in advance for your help!
Steve & Shannon Cook
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/
