Thanks a lot. It works perfectly both solutions.

Once again, Thanks a lot

Marco Rod

"מיכאל (מיקי) אבידן" escreveu:

I your "private case": $A$1:$D$3 might be: A1:D3
Micky


"מיכאל (מיקי) אבידן" wrote:

Two more solutions:
http://img35.imageshack.us/img35/2750/nonamecr.png
Micky


"Marco Rod" wrote:

Hello,

I have a problem and I need a solution that I'm not finding out. I need a
formula that give me a specific value in a matrix (under the condition of
column and row).

Example: I have the matrix described below. I need a formula that gives me
how many keybords has room 1. Of course that the formula must allow me to
change the conditions of the serach.

Advisors PC Mouse keybord
Room 1 20 30 40
Room 2 30 67 90

Thanks in Advance for your support
Regards
Marco