Hi
I have a worksheet with several columns. In one column
(Source)I have serveral codes ie O P D S R. R being for
recommendations. In another columns I have the revenue
generated for each source. I.e
Date Source Rate Salesman
12/3/05 R 14,000 LJ
14/3/05 S 22,000 HK
15/3/05 S 11,000 LJ
18/3/05 R 8,000 TT
I need to be able to pick out just the Rs and get a sum
of the rate please.
Thank you.
S