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)

[TABLE="width: 192"]
<TBODY>[TR]
[TD="class: xl63, width: 64, bgcolor: transparent"]C[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]D[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]E[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent, align: right"]F[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]Ledger
[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]LEDGER
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]Led ger
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]#REF!
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]#NA
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]2
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]#N/A
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]#REF
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]2
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]#N/A
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]3
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]#REF!
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Ledger
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]LEDGER
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Led ger
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
</TBODY>[/TABLE]

 

[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?