# Formula help for beginner

Wincleaner
Guest
Posts: n/a

 21st Mar 2010
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

Don Guillett
Guest
Posts: n/a

 21st Mar 2010
=SUMPRODUCT((D26={"paid","cheque"})*C2:C6)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Wincleaner" <(E-Mail Removed)> wrote in message
news:A5AE0180-2D79-4B6E-9790-(E-Mail Removed)...
> 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

Teethless mama
Guest
Posts: n/a

 21st Mar 2010
=SUM(SUMIF(D26,{"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

Ashish Mathur
Guest
Posts: n/a

 22nd Mar 2010
Hi,

=sumif(D26,"Paid",C2:C6)+sumif(D26,"cheque",C2:C6)

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Wincleaner" <(E-Mail Removed)> wrote in message
news:A5AE0180-2D79-4B6E-9790-(E-Mail Removed)...
> 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 Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post JPorter Microsoft Excel Misc 3 2nd May 2008 06:41 PM Ted Microsoft Excel Discussion 6 1st Dec 2005 06:53 PM =?Utf-8?B?S3VydCBTY2hyb2VkZXI=?= Microsoft ASP .NET 7 3rd Feb 2005 03:47 PM Robert11 Microsoft Excel Discussion 2 16th Jan 2004 03:54 AM -\$- Windows XP Internet Explorer 2 21st Dec 2003 11:45 PM

Features