You don't need lookup. Try this:

=SUMIF(S:S,"D",R:R)

=SUMIF(S:S,"C",R:R)

HTH,
Paul

"Ashley" wrote in message
...
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?