Countif with one range to values added to give one total....

Hello

I`m new here and need a little help

currently trying to get countif to add two different values and give one total,
I need this

=COUNTIF(A3:AH3,"P")

Plus

=COUNTIF(A3:AH3,"P2")

in one total, so it will add all the P's and P2's but P=1 and P2=2...

so if i have 3 p's and 1 p2 the total should be 5.

How can I do this ?

Originally Posted by Special-K

in the same cell
=COUNTIF(A3:AH3,"P")+COUNTIF(A3:AH3,"P2")

I tried that but it just adds the P's and P2's.

Imagine that P=1 and P2=2,
I have 3x P and 1 x P2 = 5, but this just returns 4...

Any ideas ? do I need Countif?

Try

=COUNTIF(A3:AH3,"P")+COUNTIF(A3:AH3,"P2")*2

I don't think that's what OP said.

From post #3

Imagine that P=1 and P2=2,
I have 3x P and 1 x P2 = 5, but this just returns 4...

P has a value of 1, P2 has a value of 2
There are 3 P's and 1 P2 so that's
=3 x 1 + 1 x 2
=3 + 2
=5

Originally Posted by Cutter

Try

=COUNTIF(A3:AH3,"P")+COUNTIF(A3:AH3,"P2")*2

That worked...

Originally Posted by alimamak

cutter, that formula will give multiply of p2 if i not mistake

so from info u give
=COUNTIF(A3:AH3,"P")+COUNTIF(A3:AH3,"P2")*2

Originally Posted by alimamak

= (3 of p)+((1 of p2)times 2)
= 3+2
= 5

so is that the answer u expected?

Confused, as that gives the same result.

Originally Posted by Cutter

I don't think that's what OP said.

From post #3

P has a value of 1, P2 has a value of 2
There are 3 P's and 1 P2 so that's
=3 x 1 + 1 x 2
=3 + 2
=5

Exactly, but it doesn't really matter because i got the result i needed.

Now anyone know about percentages?