Is it possible to have multiple criteria in SUMIF formula?
For example, In Sarah's example, sum all checks if drawn on specific bank.
Bank name will be a separate column.
I have similar problem where I am trying to add quantity of stocks if it
matches the Company name and if it is a Buy transactions

Any help is well appreciated

Regards
Abhay

"Sandy Mann" wrote:

You are very welcome, thanks for the feedback

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Sarah" wrote in message
...
Thanks for the help, made it very easy!
--
Regards,
Sarah


"Sandy Mann" wrote:

For Cash use:

=SUMIF(J3:J10,1,K3:K10)

For Cheques use:

=SUMIF(J3:J10,2,K3:K10)

Adjust the ranges to suit your spreadsheet.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Sarah" wrote in message
...
Hi,
I have set up a stocklist worksheet, and have column J entitled PAYMENT
METHOD, in cell J4, I have put number 1 (to represent CASH PAYMENT),
number
2(to represent cheque payment, with the amount paid in column K, and
the
description of the item in column B. I want to enter a formula that
calcutes
the CASH amounts from column K, when column J says 1, and the same for
cheque
amounts when column J says 2??? Have been playing, but just can't
figure
out
how to achieve this.
--
Thank you,
Sarah