Count values in a column

[chatternet]

He Dear,

I am fresh on this forum. This afternoon I had make some table for plan vs actual. Relatively I wanted to count the values input in a column, i.e.

In column C I had and In Column D I had
PP P

So I wanted to count those values, So in manual calculation the total is 3. Why

Because PP represent that employee A has a target to comply 2 plans in one day. And employee B had a target 1 only.

Can anybody help me on this on how to figured out.

Regards,

[NBVC]

Try something like:

=SUMPRODUCT(--(LEN(C1:D4)-LEN(SUBSTITUTE(C1:D4,"P",""))))

adjust the ranges to suit.

This counts the number of "P's" in the range.

[chatternet]

Hi Dear,

Thank you so much for your assistance, today I get the solution.

Regards,

[Richard Buttrey]

Hi,

It's not clear exactly how this data is laid out and whether you're wanting to count all values in the whole columns or just the values on a particular row. And then what do you mean by value? is 'PP' a count of 2 because there are two characters? If all 'values' are made up of single characters and you want to count on each row then

=LEN(A1)+Len(B1)

Regards

[NBVC]

For the sake of future followers looking for similar issue, please indicate what solution worked for your needs.

[papgas]

I have a column of discriptions (one in each row) and next to it another column with values through formulas.
I can use the "MINA" function to find and present the minimum value, but:

What if there are two or more equal ones?
How can I present the discription corresponding to the min value, before or next to it (the min value) ?

Thank you in advance.

[Richard Buttrey]

Hi,

This appears to be a new request. If so you should start a completely new thread.

Regards

[papgas]

Hi,

This appears to be a new request. If so you should start a completely new thread.

Regards

It is my first request so, it is new, if that is what you mean
If it is not define what you mean (I am a new comer) and enlight me on how the new thread should be named and what category should it be opened in.
Thank you for your time.
Yours,
Constantine

[Richard Buttrey]

Hi Constantine,

No, What I meant is that you have jumped into a pre-existing thread, started by someone else and are asking a different question.

You should start a completely new thread.

Regards