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

Counting and multiplying
 

Have you tried =COUNTIF(T1:T100,"X")*4 ?

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Randi" wrote in message
...
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

Counting and multiplying
 

Column Q x 1, Column R x 2, Column S x 3, Column T x 4

Think you could try something like this
in say, V1:
=COUNTIF(Q:Q,"x")*COLUMNS($A:A)
V1 returns the result for col Q.
Copy V1 across to Y1 to return the corresponding results for cols R to T.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Randi" wrote:
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

Counting and multiplying
 

Thanks - that's what I needed.

"Bernard Liengme" wrote:

Have you tried =COUNTIF(T1:T100,"X")*4 ?

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Randi" wrote in message
...
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