Add totals based on more than one criteria

[Quo.vadio]

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

 

[T. Valko]

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)

 

[Adilson Soledade]

Search for the uses of the SUMPRODUCT function. I recommend these links:
http://www.meadinkent.co.uk/xlsumproduct.htm
http://www.bygsoftware.com/Excel/functions/sumproduct.htm
http://www.bettersolutions.com/excel/EDH113/QU014532021.htm
Good Luck

 

[John C]

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