Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum
I have 2 colums A and B. I want to sum a total of B only where A=Y??
Thanks A B Y $9,290.41 Y $9,290.41 Y $8,740.94 Y $8,740.94 Y $8,280.00 Y $8,280.00 Y $6,375.00 Y $6,375.00 Y $5,760.00 Y $5,760.00 Y $5,277.43 Y $5,277.43 S $4,130.00 S $4,130.00 Y $4,014.55 Y $4,014.55 N $3,937.25 N $3,937.25 Y $3,474.77 Y $3,474.77 |