Adding up amounts from different columns across tabs

Hello Guru's, I bow to the gods of excel.

I really need some help adding up and separating data from across tabs for an annual amount on a final tab.

For convenience, I’ve provided the Excel sheet.

On the final TAB “FY TOTALS”, I’ve highlighted yellow the area I need help with. I have 4 different service programs, they are invoiced monthly, I need to have a formula that looks at Column C “Service” (in each tab) and calculate the monthly total “Hours” for the corresponding service. This needs to be represented in the "FY TOTALS" tab.

Hi Gak67,

Thank you for your help.

I'm updating each tab to exactly match the corresponding months in the dashboard (FY TOTALS).

I'm having some difficulty with the formula provided (it looks very complex to me!). How do I change that formula to calculate the different services hours for (each service), each month?

Thanks,

QM