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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum
Use SUMIF()
=SUMIF(A:A,"Y",B:B) If this post helps click Yes --------------- Jacob Skaria "Max" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum
hi
try this =SUMIF(A2:A22,"y",B2:B22) regards FSt1 "Max" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|