Looking for formula that would create an average from certain criteria with in excel

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Looking for formula that would create an average from certain criteria with in excel

FAQ

Thread Tools

Display Modes

07-29-2014, 07:30 AM

bdouglas1011 bdouglas1011 is offline

Windows 7 64bit Looking for formula that would create an average from certain criteria with in excel

Office 2013

Novice

Join Date: Jul 2014

Posts: 5

Expanding the range

Some of the sheets I apply this formulas to has more and some has less rows. Can I not just go in the formula and change the range ($d$2:$d$69) just change the 69 to say 300 and the other corresponding parts to expand for more rows in other sheets. I tried that and now the data returns as Zero or extremely off.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Average over all pivot rows in excel	Andrey	Excel	2	07-23-2014 07:51 AM
formula to find 2 or more criterias then average the sum	samtitus	Excel	6	02-17-2014 10:16 PM
Formula with 3 Criteria	bremen22	Excel	3	09-24-2013 11:39 AM
Excel 2010 formula rounds - arithmetic average calculation	YooNaa Kim	Excel	1	06-07-2011 08:50 PM
'AVERAGE' Formula	nfphilpot	Excel	3	11-24-2010 02:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:09 AM.