From: Wincleaner on 21 Mar 2010 16:56 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 From: Don Guillett on 21 Mar 2010 17:07 =SUMPRODUCT((D2:D6={"paid","cheque"})*C2:C6) -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Wincleaner" wrote in message news:A5AE0180-2D79-4B6E-9790-F896345CB737(a)microsoft.com...> 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 From: Teethless mama on 21 Mar 2010 18:21 =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 From: Ashish Mathur on 21 Mar 2010 22:40 Hi, =sumif(D2:D6,"Paid",C2:C6)+sumif(D2:D6,"cheque",C2:C6) -- Regards, Ashish Mathur Microsoft Excel MVP "Wincleaner" wrote in message news:A5AE0180-2D79-4B6E-9790-F896345CB737(a)microsoft.com...> 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  |  Pages: 1 Prev: Automating a WorksheetNext: Excel "data base engine failure"?