or even

=SUMPRODUCT(SUMIF(D1:D10,{"C","D",""},R1:R10))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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?