Try something like this.

List your criteria in a range of cells:

E1 = start date
F1 = end date
G1 = method type

Then your formula is:

=SUMPRODUCT(--(B1:B100=E1),--(B1:B100<=F1),--(C1:C100=G1),A1:A100)

--
Biff
Microsoft Excel MVP


"Quo.vadio" wrote in message
...
how can I add totals from one column based on criteria in two other
columns.

For example. I need to add the total amount of payments received between
two dates, based on the method of payment

Columns are A: amount Payed B: Date C: Method (e.g. check,
cash,
etc.)