I want to sum values from a table I have. I try to describe it here.
This is how the table looks like.
Year Hours Injuries
2000 2 1
2001 5 2
2002 4 1
2003 9 3
Under this table I have made two drop down list so I can choose "From year" to "To Year".
Under this I want to it to sum up all the values for number of "Hours" and number of "Injuries" from the years I have chosen.
I have tried to make a SUMIF function but it isn't correct. What I have written is:
SUMIF($A$3:$A$19;">"&$B$23;$C$3:$C$19) where column A is years, B is Hours and where I choose "From year", and C is Injuries and "To year". With this code it doesn't matter what I choose in "To year".
I would appreciate all the help I can get :)