View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Randi Randi is offline
external usenet poster
 
Posts: 28
Default Counting and multiplying

I am using the countif formula to count the Xs in each column -
What I really want is a total that counts the Xs in a column and then
multiplies that count by a number, i.e.:

Column Q x 1, Column R x 2, Column S x 3, Column T x 4, etc.
Can I add to the countif formula to count the Xs in column T and multiply by 4
so a total for column T would be 4 instead of 1.
P Q R S T
7 X
8 X
9 X
10 X
11 X

Thanks