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

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" <(E-Mail Removed)> wrote in message
news:196AC8B6-6A31-4EAA-AE20-(E-Mail Removed)...
> 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.)

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

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