Find values based on colum and sum in a table

Hello,



I have an Excel spreadsheet where I pull in data from another source into columns A1-BS. I then want to look at the last line, here the 3/15/2012 12:43:56 and get the number. This could change and the first column might not be 3, New

I want to look at 3 and New and know the value 1 needs to be placed in the new 3 table cell below. Any suggestions on how to handle this????

3 3
Date / Time New In Progress
03/15/2012 12:27:28 1 0
03/15/2012 12:41:36 1 0
03/15/2012 12:43:56 1 0


| SEVERITY |
STATE | 1 2 3 4 5 |TOTAL
---------- ------ ------ ------ ------- ----- ------ --
new | 0 0 1 0 0 | 1
in progress | 0 0 0 0 0 | 0
resolved | 0 0 0 1 0 | 1
feedback | 0 0 0 0 0 | 0
closed | 0 0 0 0 0 | 0
rejected | 1 0 0 0 0 | 1
review | 0 0 0 0 0 | 0
returned | 0 0 0 0 0 | 0
reviewing | 0 0 0 0 0 | 0
merging | 0 0 0 0 0 | 0
testing | 0 0 0 0 0 | 0
---------- ------ ------ ------ ------- ----- ------ --
TOTAL | 1 0 1 1 0 3