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

try
=sumif(source column,"R",rate column)

"Sal" wrote:

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

Hi
Tried that but gave NAME? error.
Sal
-----Original Message-----
try
=sumif(source column,"R",rate column)

"Sal" wrote:

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

.

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)

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


" wrote:

Hi
Tried that but gave NAME? error.
Sal
-----Original Message-----
try
=sumif(source column,"R",rate column)

"Sal" wrote:

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

.

Hi
Thanks for the advice will try them all.
Will be back I am sure with more queries.
Regards.
S
-----Original Message-----
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)

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


" wrote:

Hi
Tried that but gave NAME? error.
Sal
-----Original Message-----
try
=sumif(source column,"R",rate column)

"Sal" wrote:

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

.


.