Otto
Thanks for that, sorry if it was not clear.

Data is entered in this section
I would like to choose the selection for pay method by drop down list.

Pay Bus
Date Method Fuel Stock Phone Stationary Travel
4/04/2008 Card £79.99
04/04/2008 Bank £11.55
07/04/2008 Cash £2.94
08/04/2008 Chq £6.07
02/04/2008 Card £15.78
02/05/2008 Bank £10.99
03/05/2008 Cash £3.88
================================================== ===
Totals in the month are listed in another part on the sheet to show monthly
totals by type of payment.If it makes it easier I could use one sheet for
each month thus simplifying the date sorted.

Any help would be greatly appreciated and thanks for guidance so far.

John


Card Cash Chq Bank
Fuel £95.77
Bus Stock
Phone £22.54
Stationary £2.94
Travel £6.07

================================================== =
"Otto Moehrbach" wrote:

John
You have to provide the logic behind what you want to happen for anyone
to help you. You say "fuel that falls in the month". What month? Provide
some logic of what you want by month. You said that you want to copy
something to another sheet. What do you want to copy? Where do you want to
place it? It would help if you provided a step-by-step procedure of what
you would do if you were doing it all manually. HTH Otto
"John cheshire lad" wrote in
message ...
I Have rows of input data as follows under
Date Pay type, Tools, fuel, Hotel
etc
2/5/08 card ( from Drop down) 10.52
6/5/08 cash 12.55

I need to extract data that meets the criteria of where the monet was
spent
for , i.e. fuel that falls in the month.
I have created a drop down list to select type of payment and then I would
enter the amount under the particular heading.
Can I use sumproduct for the date but can it be used also with an array as
in the drop down list.
Any help would be much appreciated.



"Otto Moehrbach" wrote:

What constitutes a match? Otto
"John cheshire lad" wrote in
message ...
I am trying to do a spreadsheetfor my accounts.I need to create a drop
down
list of payment type i.e card, cash, cheque.
I need to enter a row of data as eg
Date, supplier, drop down List,materials, legal fees, etc.

if the date and drop down crieria match I want to copy the materials
cell
to
another sheet.
hope you can help