Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Only chart numerical values, not error values | Charts and Charting in Excel | |||
Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
How to equate Text Drop Down selections to numerical values | Excel Discussion (Misc queries) | |||
text has numerical values | Excel Worksheet Functions | |||
Assign numerical values to text codes | Excel Worksheet Functions |