# Immediate Count Required

##### Active Member
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

 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

#### Attachments

• 11 KB Views: 3

#### NARAYANK991

##### Excel Ninja
Hi ,

See if the logic in the attached file is correct.

Narayan

#### Attachments

• 12.1 KB Views: 10

##### Active Member
Dear Sir,

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

regards
Naresh

#### NARAYANK991

##### Excel Ninja
Hi ,

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

Narayan

##### Active Member
Dear Sir,

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

regards
Naresh

#### NARAYANK991

##### Excel Ninja
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

##### Excel Ninja

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

##### Active Member
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