Count returns for a period - year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to count staff survey results & compare year on year results
They score 1-10 for a number of questions
Date Score
Mar-2004 8
Apr-2004 9
Jul-2004 4
Jul-2004 7
Jul-2004 8
Jul-2004 9
Jul-2004 8
A similar set of results for2005 is produced and added to the bottom of the
list

How do I calculate the number of "8" scored in 2004; 2005 etc

Thanks for any help!
 
One way
=SUMPRODUCT(--(YEAR($A$2:$A$100)=2004),--($B$2:$B$100=8))

Rather than hardcoding the 2004 and 8 into the formula, if you put Year in
D1 and Number inE1 then just cahnging these values would give you the other
results quickly
=SUMPRODUCT(--(YEAR($A$2:$A$100)=D1),--($B$2:$B$100=E1)
Change ranges to suit
 
Back
Top