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?
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.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.


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.
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.