Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help for beginner
Hello,
All I want to do is Column C is an amount Column D is a drop down list of Paid, Unpaid, Cheque If Column D = Paid or Cheque I want to calc the sum of the corresponding C amounts C D 5 Paid 5 Cheque 5 Unpaid 5 Unpaid 10 Paid total = £20 Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help for beginner
=SUMPRODUCT((D2:D6={"paid","cheque"})*C2:C6)
-- Don Guillett Microsoft MVP Excel SalesAid Software "Wincleaner" wrote in message ... Hello, All I want to do is Column C is an amount Column D is a drop down list of Paid, Unpaid, Cheque If Column D = Paid or Cheque I want to calc the sum of the corresponding C amounts C D 5 Paid 5 Cheque 5 Unpaid 5 Unpaid 10 Paid total = £20 Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help for beginner
=SUM(SUMIF(D2:D6,{"Paid","Cheque"},C2:C6))
"Wincleaner" wrote: Hello, All I want to do is Column C is an amount Column D is a drop down list of Paid, Unpaid, Cheque If Column D = Paid or Cheque I want to calc the sum of the corresponding C amounts C D 5 Paid 5 Cheque 5 Unpaid 5 Unpaid 10 Paid total = £20 Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help for beginner
Hi,
=sumif(D2:D6,"Paid",C2:C6)+sumif(D2:D6,"cheque",C2 :C6) -- Regards, Ashish Mathur Microsoft Excel MVP "Wincleaner" wrote in message ... Hello, All I want to do is Column C is an amount Column D is a drop down list of Paid, Unpaid, Cheque If Column D = Paid or Cheque I want to calc the sum of the corresponding C amounts C D 5 Paid 5 Cheque 5 Unpaid 5 Unpaid 10 Paid total = £20 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula question from beginner | Excel Discussion (Misc queries) | |||
Excel Beginner, | Excel Worksheet Functions | |||
Beginner Question | Charts and Charting in Excel | |||
2 questions from a beginner | New Users to Excel | |||
Macro for a beginner | Excel Discussion (Misc queries) |