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

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

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

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