Thread
:
Beginner in excel
View Single Post
#
5
Posted to microsoft.public.excel.misc
Sarah
external usenet poster
Posts: 231
Beginner in excel
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
Reply With Quote
Sarah
View Public Profile
Find all posts by Sarah