text and numerical values in two columns
 

I have two columns, one with either the letter R or F. In the other column
there are various numbers (volumes). I need a formula that tells me how to
add up all the volumes associated with R (or of course F)

eg

Vol F/R
6 F
8 F
12 R
98 F
27 R

etc

Can you help please
--
Bev

text and numerical values in two columns
 

enter:
=SUMPRODUCT(A1:A100,--(B1:B100="F"))

and then

=SUMPRODUCT(A1:A100,--(B1:B100="R"))


(adjust the 100 to suit)
--
Gary''s Student - gsnu200788


"Bev" wrote:

I have two columns, one with either the letter R or F. In the other column
there are various numbers (volumes). I need a formula that tells me how to
add up all the volumes associated with R (or of course F)

eg

Vol F/R
6 F
8 F
12 R
98 F
27 R

etc

Can you help please
--
Bev

text and numerical values in two columns
 

Hello Bev,

You can do this by using SUMIF function. Lets say your data starts in cell
A1, the formula would be sumif(B2:B6,"=R",A2:A6). Hope this helps you.

Satish Nelanuthala

"Bev" wrote:

I have two columns, one with either the letter R or F. In the other column
there are various numbers (volumes). I need a formula that tells me how to
add up all the volumes associated with R (or of course F)

eg

Vol F/R
6 F
8 F
12 R
98 F
27 R

etc

Can you help please
--
Bev

text and numerical values in two columns
 

=Countif(B2:B6,"F")

=Countif(B2:B6,"R")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bev" <Bev trucking wrote in message
...
I have two columns, one with either the letter R or F. In the other column
there are various numbers (volumes). I need a formula that tells me how to
add up all the volumes associated with R (or of course F)

eg

Vol F/R
6 F
8 F
12 R
98 F
27 R

etc

Can you help please
--
Bev