Add totals based on more than one criteria
 

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

Add totals based on more than one criteria
 

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

Add totals based on more than one criteria
 

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


--
Adilson Soledade


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

Add totals based on more than one criteria
 

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