Count if column A cell contains specific text, but the output has an error...

[copperwasher]

hi there.

This formula was designed for me, but it has an error, which needs a resolve or rewrite...

[I needed to count plus one, each time a specific company name appeared in Column A, calc the count in column B]

The provided formula
=MAP(SEQUENCE(COUNTA(A:A)-1)+1,LAMBDA(x,INDEX(A:A,x)&" "&COUNTIF(A2:INDEX(A:A,x),INDEX(A:A,x))+100))

How do I use this formula, if column A has blank cells??

When there are blank cells in Column A, column B cell produces 100, this needs to be blank

Currently, column A cell is blank,
Column B cell is 100

Name	Count
company B	company B 101
company A	company A 101
company A	company A 102
company A	company A 103
company C	company C 101
	100
company B	company B 102
company A	company A 104
company A	company A 105

Ideally
Column A cell is blank, Column B cell is blank

Name	Count
company B	company B 101
company A	company A 101
company A	company A 102
company A	company A 103
company C	company C 101
company B	company B 102
company A	company A 104
company A	company A 105

Any guidance is very much appreciated.

With sincere thanks
Gary

 

[Fluff]

Duplicate to: Add to the count if the cell contains a specific name...

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.