excel �以利用 countif 計算已知�域的目標數目,但是countif無 法分辨大�寫,如 "1b" or "1B".
è«‹å•�有什麼函數å�¯å�šåˆ°æ*¤åŠŸèƒ½å‘¢?

As COUNTIF is not case sensitive,
one way to get counts which need to be case sensitive ..

Assuming data is within A1:A100

To count no. of cells with "1b" :
=SUMPRODUCT(--(ISNUMBER(FIND("1b",A1:A100))))

To count no. of cells with "1B" :
=SUMPRODUCT(--(ISNUMBER(FIND("1B",A1:A100))))

Adapt the ranges to suit ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"tree" wrote in message
...
excel ???? countif ???????????,??countif???????,? "1b" or "1B".
???????????????

How distinguishes the big small letter?
Excel may calculate the known region using countif the goal number, but
countif is unable to distinguish the big small letter, like "1b" or "1B"
Asked what function has to be possible to achieve this function?