Microsoft Office Forums - View Single Post - [Solved] Need Multiple Formulas Pulled from a data chart

Thread: [Solved] Need Multiple Formulas Pulled from a data chart

View Single Post

Old

03-20-2017, 07:42 AM

gebobs

gebobs is offline

gebobs uses Windows 7 64bit

Windows 7 64bit gebobs uses Office 2010 64bit

gebobs uses Office 2010 64bit

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

gebobs has a spectacular aura about

gebobs has a spectacular aura about

Default

Quote:

Originally Posted by rccolb

View Post

So First off I will need a formula to total the Internal Jobs and then Average, External Jobs then Average.

What do you mean by "total"? A count or a sum? At any rate, you may be able to use countif, sumif, and averageif.

Reply With Quote