|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 21st, 2010, 08:56 PM
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
March 21st, 2010, 09:07 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help for beginner
=SUMPRODUCT((D2
 6={"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
March 21st, 2010, 10:21 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help for beginner
=SUM(SUMIF(D2
6,{"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
March 22nd, 2010, 02:40 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help for beginner
Hi,
=sumif(D2 6,"Paid",C2:C6)+sumif(D26,"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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
