Summary Sheet??

[Ket]

Hello,

I have a spreadsheet that amongst other things has a column that
contains a year and in another column contains a status. This status
is a number between 0 and 10.
I also have a summary sheet.
In column A, I have the status 1 down to 10. The row headers are the
years, 2001, 2002, 2003, 2004 etc.
I need to create a formula that looks at my year column and returns
the number of times a status has occurred.

eg
2001 2002 2003 etc
1 6 10 1
2 5 12 15
3 10 20 7
etc

I hope this makes sense

Thanks in advance.

Ket

 

[Guest]

Hi

Try this:
=SUMPRODUCT(--(Sheet2!$A$2:$A$1000=A$1),--(Sheet2!$B$2:$B$1000=$A2))
This can then be filled down and across your summary table.