Hi All

I need to display the sum of the data based on the Status im not sure of whether to use vlookup for this or not kindly help in this regard

The data is like this

STATUS HOURS
ONHOLD 9
ONHOLD 10
ONHOLD 11
ONHOLD 12
ONHOLD 13
ONHOLD 14
ONHOLD 15
ONHOLD 16
ONHOLD 17
ONHOLD 18
INPROGRESS 35
INPROGRESS 36
INPROGRESS 37
INPROGRESS 38
INPROGRESS 39
INPROGRESS 40
INPROGRESS 41
INPROGRESS 42
INPROGRESS 43


Expected Output in another cell should be based on the status for sum of all these hours and Count of different statuses

Sum Count
For Onhold - 135 10

InProgress - 351 9

Sample.xls


PS:At present I know the range of cells but infuture i may not know the range it would be good if i get an output anticipating this future change


Thanks in Advance