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.

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.

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.

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.