Summary Sheet??

  • Thread starter Thread starter Ket
  • Start date Start date
K

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
 
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.
 
Back
Top