Thread: IF and VLookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashley Ashley is offline
external usenet poster
 
Posts: 71
Default IF and VLookup

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?