Sum of a column

S

Sal

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
 
B

bj

If you specified the entire column there may have been something it didnt like

use just the range of data
=sumif(source range,"R",rate range)
Click to expand...

If it still doesn't work, check that the Rs are realy just "R" with
something like
=if(cell="R","yep", "Nope")
on a couple of the cells with R in them
you may have to use the clean function if there are addtitional things in
the cells
 
G

Guest

Hi
Thanks for the advice will try them all.
Will be back I am sure with more queries.
Regards.
S
 
Top