try this

in C1 put this formula ( use ctrl + shift + enter )
=COUNT(IF(A1:A7&B1:B7=20&"ALPHA",))

in C2 put this formula ( use ctrl + shift + enter )
=COUNT(IF(A1:A7&B1:B7=40&"ALPHA",))


to hide the formula displayed in formula bar
Select the sheet ( Ctrl + A ) | go to format | cells | protection tab
| uncheck both locked & hidden |
now select the cell which needs to hide the formula | go to format |
cells | protection tab | check both locked & hidden | ok |
now go to tools | protection | protect sheet ( password optional | ok




On Oct 19, 2:02*pm, Malik Nadeem
wrote:
i have one question is it posible example are as under
* * * * A * * * B * * * C * * * D * * * E * * * ......
1 * * * 20 * * *ALPHA
2 * * * 40 * * *BRAWO
3 * * * 40 * * *CHARLE
4 * * * 20 * * *BRAWO
5 * * * 40 * * *ECHO
6 * * * 20 * * *ALFA
7 * * * 20 * * *CHARLE

in above how many 20 of ALPHA and how many 40? need result sapret
like
ALPHA * 20=2 TIMES
* * * * * * 40=0 TIMES

and also i want to know how to hide the same formula in cell but cell will
work no body can veiw and change that formula in resulting cell.

regards
Malik Nadeem
Cell # 00971-50-9122837