Excel calculate field property from various places in Sheet

I need to calculate  Totals for (Billable Hours i3, Non-Billable Hours i4, Overtime Hours i5) from various places in the  Worksheet.
How do i go about it.
Please see the attached  simple worksheet.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saqib Husain, SyedEngineerCommented:
What do you mean by

from various places in the  Worksheet
Select I2. From the Home Tab - Editibg Group Select Auto Sum. Select F14 then drag to L14. Select enter. Repeat for the other categories. See attached.

Disregard my last post. I think I see what you're looking for. You can use Sumif. For I3 the formula would be:


What the formula does is look in column E, rows 14-27. If it finds the criteria, "Billable", it will add the figure located in column M on that same row.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

ProfessorJimJamMicrosoft Excel ExpertCommented:

you might wanna see my solution it is rowbust, no matter howmuch more rows you add, it works.

in your original file, you had a missing referrence of F16 which i also fixed in the attached version

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
icdl101Author Commented:
Thank you Flyster and ProfessorJimJam.

Both of your solutions work equally well.
I have tested them out both.
By the way Flyster, your solutions works well even when you add extra rows.
ProfessorJimJamMicrosoft Excel ExpertCommented:
Thx icdl101 for the feedback

You are welcome
icdl101Author Commented:
Extremely fast and relevant responses from 2 Great Experts

Sorry guys would have split the points evenly but the System didn't allow it.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.