Y
yoelgold
this is my excel layout. i want a total of the amount field where
description ends with "R" or where description ends with IV OR if it
ends with "R IVY". i tried this =SUM(IF(B2:B40=RIGHT("R"),)*C2:C40) it
gave me 0.00
date description amount
6/10/05 Deposit IV ($961.00)
3/16/05 Deposit M ($5,000.00)
4/20/05 Deposit M ($25,000.00)
6/8/05 Deposit M ($6,077.72)
6/30/05 Deposit M ($4,171.70)
5/20/05 Deposit R ($100.00)
6/1/05 Deposit R ($30.00)
6/13/05 DEPOSIT R ($4,096.00)
6/20/05 DEPOSIT R ($2,340.00)
6/24/05 DEPOSIT R ($1,780.00)
6/27/05 DEPOSIT R ($2,210.00)
6/30/05 DEPOSIT R ($3,300.00)
7/5/05 DEPOSIT R ($4,844.00)
7/7/05 DEPOSIT R ($5,261.19)
7/19/05 DEPOSIT R ($3,155.00)
7/20/05 DEPOSIT R ($835.00)
7/20/05 DEPOSIT R ($812.05)
7/21/05 DEPOSIT R ($130.00)
7/12/05 DEPOSIT R IVY ($3,856.75)
description ends with "R" or where description ends with IV OR if it
ends with "R IVY". i tried this =SUM(IF(B2:B40=RIGHT("R"),)*C2:C40) it
gave me 0.00
date description amount
6/10/05 Deposit IV ($961.00)
3/16/05 Deposit M ($5,000.00)
4/20/05 Deposit M ($25,000.00)
6/8/05 Deposit M ($6,077.72)
6/30/05 Deposit M ($4,171.70)
5/20/05 Deposit R ($100.00)
6/1/05 Deposit R ($30.00)
6/13/05 DEPOSIT R ($4,096.00)
6/20/05 DEPOSIT R ($2,340.00)
6/24/05 DEPOSIT R ($1,780.00)
6/27/05 DEPOSIT R ($2,210.00)
6/30/05 DEPOSIT R ($3,300.00)
7/5/05 DEPOSIT R ($4,844.00)
7/7/05 DEPOSIT R ($5,261.19)
7/19/05 DEPOSIT R ($3,155.00)
7/20/05 DEPOSIT R ($835.00)
7/20/05 DEPOSIT R ($812.05)
7/21/05 DEPOSIT R ($130.00)
7/12/05 DEPOSIT R IVY ($3,856.75)