Euro-Coin Database

[The.General]

Hello all,

I'm new on this forum.
My native language is not English but i will try to explain the problem in English.

My hobby is to collect Euro-coins.
I want to insert my collection in a Excel sheet.

To achief this i have made a tab called "Input".
Here i will insert the coins i bought.

There will be 2 variables: The Country and the year

Picture link: http://img96.imageshack.us/i/inputi.png/

When i insert the data i want to show them in a matrix on another tab:

Picture link: http://img809.imageshack.us/i/matrixd.png/

For example: When i insert "Nederland" (The Netherlands) and 1999 on the input tab i want that Excel show on the other tab a 1 in the correct country matrix and correct year.

I tried different formulas like INDEX and MATCH but it is still nog working.
Mabey someone will be able to help me with this problem.

Thanks in advance

 

[GlennUK]

And which of the columns in the matrix are supposed to have the "1"? All of the coin sizes?

 

[The.General]

Yes, it is supposed to have the 1 in every horizontal row.
The input is for all of the 8 coins per year

 

[GlennUK]

I do not know how you country matrices are arranged, but this will work for the Nederlands one you've shown:

=SUMPRODUCT(--(Input!$C$1:$C$999=$B5)*--(Input!$B$1:$B$999=$B$4))

entered in cell C5, and copied across and down, at a guess.

 

[The.General]

Thank you very Much GlennUK!
It is working just like i wanted. Thank you again