| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting text cells then multiplying by a value in another column
Hello,
I need some help, im trying to use COUNTIF to count certain values in a range of cells then multiply by a value in a corresponding column to those cells that have those values. For Example: Col A, Col B OS, 3 M, 2 S, 3 OS,2 L, 2 OS,3 What i need is say to count all the "OS" in Col A then multiply by corresponding value in Col B. Perhaps I am trying to use the wrong function. Help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting text cells then multiplying by a value in another column
What i need is say to count all the "OS" in Col A
then multiply by corresponding value in Col B. Do want a conditional *sum* ? =SUMIF(A1:A6,"OS",B1:B6) Result = 8 -- Biff Microsoft Excel MVP "Jo" wrote in message ... Hello, I need some help, im trying to use COUNTIF to count certain values in a range of cells then multiply by a value in a corresponding column to those cells that have those values. For Example: Col A, Col B OS, 3 M, 2 S, 3 OS,2 L, 2 OS,3 What i need is say to count all the "OS" in Col A then multiply by corresponding value in Col B. Perhaps I am trying to use the wrong function. Help! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting text cells then multiplying by a value in another column
What i need is say to count all the "OS" in Col A then multiply by
corresponding value in Col B I'm not really sure on your intents as expressed above ? Perhaps you could illustrate by describing what is the result for OS, M, S, L based on the sample data that you posted ? Maybe you meant to sum up all values in col B for OS, then do likewise for M, S, L ? If so, you could try a pivot table, its fast n easy to set it up. Just place the header for col A in the ROW area, and the header for col B in the DATA area (it'll appear as Sum of ... ). The pivot will return both the uniques listing of items (from col A) in its left col, with the corresponding sums for each item next to it. -- Max Singapore http://savefile.com/projects/236895 Downloads:17,700 Files:359 Subscribers:55 xdemechanik --- "Jo" wrote: I need some help, im trying to use COUNTIF to count certain values in a range of cells then multiply by a value in a corresponding column to those cells that have those values. For Example: Col A, Col B OS, 3 M, 2 S, 3 OS,2 L, 2 OS,3 What i need is say to count all the "OS" in Col A then multiply by corresponding value in Col B. Perhaps I am trying to use the wrong function. Help! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting text cells then multiplying by a value in another col
Thankyou, i was definetly trying to use the wrong function.
It worked. :-) "T. Valko" wrote: What i need is say to count all the "OS" in Col A then multiply by corresponding value in Col B. Do want a conditional *sum* ? =SUMIF(A1:A6,"OS",B1:B6) Result = 8 -- Biff Microsoft Excel MVP "Jo" wrote in message ... Hello, I need some help, im trying to use COUNTIF to count certain values in a range of cells then multiply by a value in a corresponding column to those cells that have those values. For Example: Col A, Col B OS, 3 M, 2 S, 3 OS,2 L, 2 OS,3 What i need is say to count all the "OS" in Col A then multiply by corresponding value in Col B. Perhaps I am trying to use the wrong function. Help! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting text cells then multiplying by a value in another col
Thankyou Max, this also worked. My intents where exactly what you thought. I
was wanting to sum up all values in col B for OS and likewise for M, S, L. "Max" wrote: What i need is say to count all the "OS" in Col A then multiply by corresponding value in Col B I'm not really sure on your intents as expressed above ? Perhaps you could illustrate by describing what is the result for OS, M, S, L based on the sample data that you posted ? Maybe you meant to sum up all values in col B for OS, then do likewise for M, S, L ? If so, you could try a pivot table, its fast n easy to set it up. Just place the header for col A in the ROW area, and the header for col B in the DATA area (it'll appear as Sum of ... ). The pivot will return both the uniques listing of items (from col A) in its left col, with the corresponding sums for each item next to it. -- Max Singapore http://savefile.com/projects/236895 Downloads:17,700 Files:359 Subscribers:55 xdemechanik --- "Jo" wrote: I need some help, im trying to use COUNTIF to count certain values in a range of cells then multiply by a value in a corresponding column to those cells that have those values. For Example: Col A, Col B OS, 3 M, 2 S, 3 OS,2 L, 2 OS,3 What i need is say to count all the "OS" in Col A then multiply by corresponding value in Col B. Perhaps I am trying to use the wrong function. Help! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting text cells then multiplying by a value in another col
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Jo" wrote in message ... Thankyou, i was definetly trying to use the wrong function. It worked. :-) "T. Valko" wrote: What i need is say to count all the "OS" in Col A then multiply by corresponding value in Col B. Do want a conditional *sum* ? =SUMIF(A1:A6,"OS",B1:B6) Result = 8 -- Biff Microsoft Excel MVP "Jo" wrote in message ... Hello, I need some help, im trying to use COUNTIF to count certain values in a range of cells then multiply by a value in a corresponding column to those cells that have those values. For Example: Col A, Col B OS, 3 M, 2 S, 3 OS,2 L, 2 OS,3 What i need is say to count all the "OS" in Col A then multiply by corresponding value in Col B. Perhaps I am trying to use the wrong function. Help! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting text cells then multiplying by a value in another col
Welcome, and thanks for feeding back.
Do take a moment to press the "Yes" buttons (like the ones below) for all responses which helped -- Max Singapore http://savefile.com/projects/236895 Downloads:17,700 Files:359 Subscribers:55 xdemechanik --- "Jo" wrote: Thank you Max, this also worked. My intents where exactly what you thought. I was wanting to sum up all values in col B for OS and likewise for M, S, L. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting and multiplying | New Users to Excel | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| Counting occurances and multiplying by a quantity | Excel Discussion (Misc queries) | |||
| Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions | |||
| COUNTING TEXT CELLS IN A COLUMN | Excel Worksheet Functions | |||
Linear Mode
