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
|