How to count with in the single row horizontally

[Nipendra.dhiman]

How to count with in the single row horizontally
how to count the Stock word which is >=5
Please find the attached sheet here.


Nipendra

 

[Somendra Misra]

Hi Nipendra,

Try below formula:

=COUNTIFS($B2:$Y2,"Stock",$C2:$Z2,">=5")

Regards,

 

[Nipendra.dhiman]

I think you have not opened the attached sheet it doesn't work

please look in to.

Regards
Nipendra

 

[Somendra Misra]

Well It gave 1 as answer in your worksheet, for row 2.

Regards,

 

[Nipendra.dhiman]

No i am not understanding you,
please see the attached sheet there is row number 2 where data is in horizontally format.
every word has some number like in the beginning "bell" has 10 ...etc.
so now i want to count the "Stock" in row number 2 which is ">=5".
result should be 1.

whenever i am trying to use the coiuntifs it is not working i don't know why

Regards
Nipendra

 

[Nipendra.dhiman]

and plz ignore the first attached sheet

 

[Somendra Misra]

See the attach file. Cell E6 has formula.

Regards,

 

[bobhc]

Somendras formula is working (post number two), there is only one cell matching the criteria, V2 , I do not think you need to question Somendras ability to open an uploaded file, read it, understand the problem and post a result, if he was unable to do so I think it highly unlikely he would have attained the status of a Ninja!!

I think you have not opened the attached sheet it doesn't work

.

 

[Nipendra.dhiman]

Somendras thank you so much for your prompt response

cheers..

Nipendra

 

[Somendra Misra]

Thanks for the feedback & welcome back anytime !!

Regards,