THANKS A LOT MUDDAN

"muddan madhu" wrote:

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