Sum dollar amount if it has an "S" next to it.

[Guest]

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.

 

[Guest]

if , for example the $ amounts are in column A and the indicators are in
column B
=sumif(B:B,"S",A:A)

 

[PCLIVE]

With your "S" in column B and your dollar amounts in column A:

=SUMIF(B:B,"S",A:A)

HTH,
Paul

 

[Guest]

Thanks BJ for the help. Obviously I'm new at this.