Counting and multiplying

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Randi - 27 Aug 2007 18:22 GMT

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

Reply to this Message

Bernard Liengme - 27 Aug 2007 18:27 GMT

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

Signature

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

>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
[quoted text clipped - 12 lines]
>
> Thanks

Reply to this Message

Randi - 27 Aug 2007 18:50 GMT

Thanks - that's what I needed.

> Have you tried =COUNTIF(T1:T100,"X")*4 ?
>
[quoted text clipped - 14 lines]
> >
> > Thanks

Reply to this Message

Max - 27 Aug 2007 18:36 GMT

> 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.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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
[quoted text clipped - 11 lines]
>
> Thanks

Reply to this Message

Rate this thread: