View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jo Jo is offline
external usenet poster
 
Posts: 113
Default 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!