This is not quite the scenario but it will explain a lot easier what I am
trying to do.

In a spreadsheet I am keeping a record of the sales figures (in dollars) in
a number of stores for different months of the year.

For example Store 1 may have sale records only for Jan, March, April, July,
December.
Store 2 may be records only for Jan, May, July, Aug, November.
Store 3 records cover only Feb, March, June, July, September, October.
etc etc

I have 3 columns - Col 1 is Store name, Col 2 is Month, Col 3 is Dollars.

To make things just a little more difficult there may be a number of times
that dollars are entered for a particular store for that given month eg
Store 1 may have 3 separate entries for January and 6 separate entries for
July etc etc.

I now want to set-up a spreadsheet that shows the store name down the
left-hand side (ie left column) and the months across the top (ie top row).
Where a store number and a month match with the spreadsheet above I want the
TOTAL dollars (for that store for that month) shown in that cell. Remember
there may be more than one entry for that store for that month.

What is a way for the new spreadsheet to look at the original spreadsheet
and enter the dollars automatically?

regards

PeterH