Count if function

[vmjan02]

I have this data and i am using count if function, it's not giving me the required output, any suggestion.
simple need to count then names only if the amount is available as 1 else it will be blank

=IF(B2<>"",COUNTIF($A$2:A2,A2),"")

Names	Amount	Count function	Actual Output
ABG	12.50	1​	correct
ABG	30.42	2​
ABG
AMFI
AMFI	2.44	2​	this has to be 1
APV	0.34	1​	correct
APV	5.40	2​
AVENDUS
BANK OF MAHARASHTRA
BANK OF MAHARASHTRA
BANK OF MAHARASHTRA
BANK OF MAHARASHTRA
CEPT	0.68	1​	correct
CHATTISGARH GOVERNMENT
CHATTISGARH GOVERNMENT	2.63	2​	this has to be 1

 

[kevin9999]

Perhaps this?

test.xlsm
	A	B	C
1	Names	Amount	Count function
2	ABG	12.50	1
3	ABG	30.42	2
4	ABG
5	AMFI
6	AMFI	2.44	1
7	APV	0.34	1
8	APV	5.40	2
9	AVENDUS
10	BANK OF MAHARASHTRA
11	BANK OF MAHARASHTRA
12	BANK OF MAHARASHTRA
13	BANK OF MAHARASHTRA
14	CEPT	0.68	1
15	CHATTISGARH GOVERNMENT
16	CHATTISGARH GOVERNMENT	2.63	1
Sheet1

Cell Formulas
Range	Formula
C2:C16	C2	=IF(B2<>"",COUNTIFS($B$2:B2,"<>",$A$2:A2,A2),"")

 

[vmjan02]

=IF(B2<>"",COUNTIFS($B$2:B2,"<>",$A$2:A2,A2),"")

tried it, but not sure as i am not getting the same result

Names	Amount	Count
ABG	12.50	1​
ABG	30.42	2​
ABG
AMFI
AMFI	2.44	2​
APV	0.34	1​
APV	5.40	2​
AVENDUS
BANK OF MAHARASHTRA
BANK OF MAHARASHTRA
BANK OF MAHARASHTRA
BANK OF MAHARASHTRA
CEPT	0.68	1​
CHATTISGARH GOVERNMENT
CHATTISGARH GOVERNMENT	2.63	2​

 

[vmjan02]

=IF(B2<>"",COUNTIFS($B$2:B2,"<>",$A$2:A2,A2),"")

got this alternative and it is working

=IF(B2>0,COUNTIFS($B$2:B2,">0",$A$2:A2,A2),"")

 

[kevin9999]

Check cells B5 (the first AMFI amount) and B15 (the first CHATTISGARH GOVERNMENT amount) and ensure that both those cells are truly empty. If there's a " " (space) in either of those cells, you'd get that result.

I see since I've been typing that you've found a workable solution.

 

[vmjan02]

Check cells B5 (the first AMFI amount) and B15 (the first CHATTISGARH GOVERNMENT amount) and ensure that both those cells are truly empty. If there's a " " (space) in either of those cells, you'd get that result.

I see since I've been typing that you've found a workable solution.

yes it was completely empty, i think ia using 365 that's why it did not took the original function that you shared, but took >0

 

[kevin9999]

Understood - although I think you should mark your post #4 as the actual solution?
Regards
Kevin