Excel - it's been a while

[charlie clown]

Excel question to fill your Friday morning:

I have two worksheets:

The first worksheet has a list of Cost Centres -  (12345, 23456, 34567 etc.). They are all formatted as numbers. In addition there is a blank column where I would like to sum the number of hours relating to each Cost Centre.

The second worksheet has, on each row, the Cost Centre number, a date and a number of hours. There are thousands of rows altogether. The Cost Centre numbers in this worksheet are also formatted as numbers.

I would like to add a formula in to the 'blank' column in the first worskheet to SUM the hours per cost centre from the second worksheet.

This feels to me like it should be a fairly simple SUMIF formula but I just cannot get it to work. Any ideas?  

 

P.S. I know that I could get the sum by using a pivot table but I want to do some additional calculations with the sum totals and the pivot tool doesn't allow that.

 

Edited August 4, 2023 by charlie clown

[Gethin]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[charlie clown]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Edited August 4, 2023 by charlie clown

[Senrab_nhoj]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[charlie clown]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Nathan Explosion]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here