EXCEL HELP NEEDED

Hi

 

I have two worksheets. 

 

One listing all days against a individual contract e.g. 

 

Contracts       Days

1234            1

1234            4

1234            2

1234            9

1235            1

1235            6

1235            0

1235            11

1236            7

1236            2

1236            20

1237            1

1237            7

1237            5

1237            5 

 

 

and the other where I want to look this days total up for that contract e.g.

 

Contract              Total days

1234                  16

1235                  18 

1236                  29

1237                  18

 

 

What VLOOKUP & SUM formula would I use as column one would not work as it is SUMing rows.

 

Thanks

Sarah

By: Sarah

Leave a Reply

Your email address will not be published. Required fields are marked *