Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum dollar amount if it has an "S" next to it.
Need help, I have a home budget sheet that one column has a dollar amount in
it and in the column next to it, I put a "C" for checking or a "S" for savings. Note that in the dollar amount column there are some blank cells, and in that case there would be no "C" or "S" in the column next to it either. How can I sum all of the dollar amounts in the colum that just have a "S" in the colum next to it? Thanks for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum dollar amount if it has an "S" next to it.
if , for example the $ amounts are in column A and the indicators are in
column B =sumif(B:B,"S",A:A) "Wayne" wrote: Need help, I have a home budget sheet that one column has a dollar amount in it and in the column next to it, I put a "C" for checking or a "S" for savings. Note that in the dollar amount column there are some blank cells, and in that case there would be no "C" or "S" in the column next to it either. How can I sum all of the dollar amounts in the colum that just have a "S" in the colum next to it? Thanks for any help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum dollar amount if it has an "S" next to it.
With your "S" in column B and your dollar amounts in column A:
=SUMIF(B:B,"S",A:A) HTH, Paul "Wayne" wrote in message ... Need help, I have a home budget sheet that one column has a dollar amount in it and in the column next to it, I put a "C" for checking or a "S" for savings. Note that in the dollar amount column there are some blank cells, and in that case there would be no "C" or "S" in the column next to it either. How can I sum all of the dollar amounts in the colum that just have a "S" in the colum next to it? Thanks for any help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum dollar amount if it has an "S" next to it.
Thanks BJ for the help. Obviously I'm new at this.
"bj" wrote: if , for example the $ amounts are in column A and the indicators are in column B =sumif(B:B,"S",A:A) "Wayne" wrote: Need help, I have a home budget sheet that one column has a dollar amount in it and in the column next to it, I put a "C" for checking or a "S" for savings. Note that in the dollar amount column there are some blank cells, and in that case there would be no "C" or "S" in the column next to it either. How can I sum all of the dollar amounts in the colum that just have a "S" in the colum next to it? Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how i do describe a numerica amount to detail for exam. 10="ten" | Excel Discussion (Misc queries) | |||
formula to give text of value($1.01 = "one dollar and one cents") | Excel Worksheet Functions | |||
return payoff after "X" amount of payments | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |