=SUMPRODUCT(--($B$2:$B$100=startdate),--($B$2:$B$100<=enddate),--($C$2:$C$100=method),($A$2:$A$100))

startdate, stopdate, and method are whatever cell references you need to be.
The range is from row 2 to 100, expand as needed (and they all should be same
length).
--
John C


"Quo.vadio" wrote:

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.)