Count various cell values

[hsandeep]

In column C, I generate various values through C%:C9999. Lot of generated values are EXACT.
How to COUNT the number of various generated values in column C.
"Ledger" & "LEDGER" should be counted separately.
Similarly, "Led ger" & "Ledger" should be counted separately.
Similarly, " Ledger" & "Ledger" should be counted separately.
If a blank is generated in column C, it should be counted separately.
If a "#N/A" is generated in column C, it should be counted separately.
If a "#Ref!" is generated in column C, it should be counted separately.

Thanks in advance.

 

[lancerj017]

use countif function

 

[hsandeep]

Request you to please provide the formula as I do not case-sensitive matching at all.

 

[lancerj017]

Post Sample Data

 

[Robert Mika]

For case sensitive
=SUMPRODUCT(--(EXACT(C1:C100,{"LEDGER"})))

 

[hsandeep]

but apart from LEDGER, lot of values are generated in the column. how to count each generated values?

 

[Robert Mika]

For any text: "LEDGER"," led ger"....
=SUM(--(IF(ISERROR($C$1:$C$10),0,EXACT($C$1:$C$10,{"LEDGER"}))))

for #N/A
=COUNT(1/(IF(ISNA($C$1:$C$10),1,$C$1:$C$10)))

For #REF:
Calculate it as the last one with
=COUNTA(C1:C10)-SUM(F1:F4)

For blank:
=COUNTBLANK(C1:C10)

C	D	E	F
		Ledger	1
		LEDGER	1
		Led ger	1
#REF!		#NA	2
#N/A		#REF	2
#N/A			3
#REF!
Ledger
LEDGER
Led ger

<TBODY>
</TBODY>

 

[hsandeep]

Should I write formulas in column F SEPARATELY for '4 varieties': any text; #N/A, #REF! or blank?
How to generate column E? Moreover preferably in ascending order?

 

[Robert Mika]

Yes each formula for one entr.
E is manull typing.

First and second formula shoudl be confirm with Control+Shift+Enter

 

[hsandeep]

Yes each formula for one entr.
E is manull typing.

First and second formula shoudl be confirm with Control+Shift+Enter

Please reply below 2 points
First and second formula means for "any text" and "#N/A"?
For third & fourth formulas, no need of Control+Shift+Enter?