Prev: Automating a Worksheet
Next: Excel "data base engine failure"?
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" <Wincleaner(a)discussions.microsoft.com> 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" <Wincleaner(a)discussions.microsoft.com> 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 Worksheet
Next: Excel "data base engine failure"?