| Home |
| Search |
| Today's Posts |
|
|
|
#1
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! |
|
#2
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! |
|
#3
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! |
| 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 | |||
Hybrid Mode
