Hi

Another way will be using autofilter feature together with SUBTOTAL
function.

Somewhere into 1st row (but not into Amount column - this column must
contain only header and data) enter the formula
=SUBTOTAL(Amount,9)
, where Amount is the reference to amouint column, like F:F

Leave 2nd row empty (so 1st row isn't filtered later)

Into 3rd column enter column headers - data start from 4th column.
Select any data or header cell, and set autofilter on.

Freeze rows 1:3

Whenever you use filter on some or several columns, subtotal sums amounts
from all visible rows. Freezing top rows keeps sum and headers always
visible.
Additionally, when entering data, you can use autofilter, to display only
empty rows, or p.e. only empty rows and entries from last month (use custom
autofilter for this) etc.

And another advice: When you have in your table data from several years,
then instead of separate year and month columns, use month in format
yyyy.mm. P.e. with date in A4, you calculate month as
=TEXT(A4,"yyyy.mm")
or, to get it as number
=--TEXT(A4,"yyyy.mm")


Arvi Laanemets


"Stan" wrote in message
ups.com...
I agree with the advice to download the info to one sheet and then use
the pivot tables to sumarize the data. To add the month and year
should not be so difficult you can write it in one celland then COPY
and PASTE down. That should not take much more than a minute to do!
The Formula is also a good solution one column for year and anoter for
month..
=year(cell)
=month(cell)
Copy and Paste.
Good luck with your secretary and have a Happy New Year!