SUMIF is great for a single criterion - for multiple criteria try SUMPRODUCT,
i.e.

If your description is in column A

=SUMPRODUCT(--($A$18:$A$20018="Buyer
Payment"),--($B$18:$B$20018<E2),$E$18:$E$20018)



"Geebz" wrote:

This one has been bugging me all afternoon, I hope someone can help.
I am trying to put together a sales report from a big list of data. A chunk
of the table looks like this:

transaction-type transaction-date amount-gbp
Buyer Payment 15/10/2006 19:29 5.49
Closing Fee 16/10/2006 12:47 -0.51
Funds Transfer Out 17/10/2006 00:00 -4.73
Withdrawal Fee 17/10/2006 00:00 -0.25
Buyer Payment 20/10/2006 17:59 4.49
Buyer Payment 23/10/2006 11:37 5.38
Closing Fee 23/10/2006 15:56 -0.42
Closing Fee 23/10/2006 15:56 -0.5
Funds Transfer Out 24/10/2006 00:00 -8.5
Withdrawal Fee 24/10/2006 00:00 -0.45
Buyer Payment 25/10/2006 18:31 3.99
Buyer Payment 25/10/2006 19:55 4.79

I am trying to produce a formulae that will be able to tell me the value of
the sales for "Buyer Payment" within a certain date range.

I've managed to successfuly use the formulae:
=SUMIF($B$18:$B$20018,"<"&E2,$E$18:$E$20018)
where "$B$18:$B$20018" is the range of dates in the table - E2 is the date
to search greater than and $E$18:$E$20018 is the ammount_GBP but this only
gives me an ammount for all transactions. How would I incorporate this
formulae to show only the "Buyer Payments" over a date range.

Many thanks.
--
There Is No Spoon!