Immediate Count Required

[Naresh Yadav]

Respected All,

I Need a formula that can allow me to get the count of Immediate Number Only
Here is the example for your reference
thanks for your help..

				Size
Location Alias	Article no	DESC	Cat	34​	36​	38​	40​	42​	44​	46​	Immediate Count
11 HAZRATGANJ LKU	CJNM0970R3BS19FL	NL-JUDE2 # MAROON	CJ		1​				2​		0
Ambience	CJNM0970V2BS19FL	NL-JUDE2 # OLIVE	CJ			3​	2​				2
Shimla	CJNM1170N2BA19FL	NL-ST-STARDUS2 # NAVY	CJ		2​		3​	1​	2​		3
Akola	CJNM1170N2BA19FL	NL-ST-STARDUS2 # NAVY	CJ	2​	3​	4​	3​		2​		4
Ambal	CJNM1170N2BA19FL	NL-ST-STARDUS2 # NAVY	CJ	1​	2​	3​		4​	5​		5
amritsar	CJNM1170N2BA19FL	NL-ST-STARDUS2 # NAVY	CJ	1​	2​	3​		4​	5​	6​	6
Rajasthan	CJNM1170N2BA19FL	NL-ST-STARDUS2 # NAVY	CJ	1​	2​	3​	4​	5​	6​		6

regards
Naresh

 

[NARAYANK991]

Hi ,

See if the logic in the attached file is correct.

Narayan

 

[Naresh Yadav]

Dear Sir,

Thank you so Much Sir for your time and effort
It works Perfectly the way I wanted..

regards
Naresh

 

[NARAYANK991]

Hi ,

But if you have a workbook with more data , please check thoroughly to ensure that it is correct.

Narayan

 

[Naresh Yadav]

Dear Sir,

thanks once again
I do check and come back to you if any issue arrives to me


regards
Naresh

 

[NARAYANK991]

Hi ,

Just to explain the logic , we can revise the formulas as follows :

In the left-most column , we only look at the column itself and its right hand side neighbour. So the formula in the first cell becomes :

=IF(AND(E3 > 0, F3 > 0), 1, 0)

In every succeeding column , we look at the column itself , and either of its neighbours. So the formula becomes :

=IF(AND(F3 > 0, OR(E3 > 0, G3 > 0)), 1, 0)

Narayan

 

[bosco_yip]

Array formula (CSE) in M3, copied down :

=SUM(0+TEXT(FREQUENCY(IF(E3:K3<>"",COLUMN($A$1:$G$1)),IF(E3:K3="",COLUMN($A$1:$G$1))),"[=1]\0;0"))

Regards
Bosco

 

[Naresh Yadav]

Dear Sir,

I have gone thoroughly to check the data which is available with me and works the same the way I wanted.. there is no changes in the the result anywhere
thanks once again for sharing the second formula which is much easier to me to understand

regards
Naresh

 

[Naresh Yadav]

Dear Bosco Sir,

Thank you so much..

regards
Naresh