=SUMIF(S1:S100,"D",R1:R100)

=SUMIF(S1:S100,"C",R1:R100)


"Ashley" wrote:

Any help is greatly appreciated.

In column S, I have either a D, a C, or a blank. Below my data I am trying
to perform the sum function for all the amounts in column R that have a D in
column S and a sum for all the amounts in column R that have a C in column S.
Is it possible to combine the SUM and IF/VLookup functions?