| 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! |
| 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 | |||
Threaded Mode
