sumproduct??

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

Ket

I have a spreadsheet that contains years in column H eg 2001 2003 2002
etc in random order and a status in column N (the status is a number
between 1 and 10)
I wish to create a summary sheet.

The summary sheet has column A headed as 'Status' and the years
(2001,2002,2003 etc) as headings on columns B->G

I need to create a formula that will look at my main spreadsheet and
return for example the number of times that the status 3 has occurred
in 2002.

The summary sheet once filled will then show the number of times a
status has occurred in any year.

TIA for all assistance.

Ket
London
 
Frank,

Thanks for your input. I wish to count the number of instances that a
status has occurred. Is SUMPRODUCT the correct function to use?

Eg in 2000 the status '9' occurred 12 times. I could then fill this
formula across my matrix.

Thanks again for any help.
 
Hi
yes for this you could use Sumproduct. Just try the example formula and
have a look at the website
 
Back
Top