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-28-2014, 12:23 PM

whatsup

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

Office 2010 32bit

Competent Performer

Join Date: May 2014

Posts: 137

Hi

Without coloring cells, just based on formulas to calculate the average regarding certain criteria.
You can include empty cells in the selceted range for calculation, it won't affect the result, but I recomend generally to keep ranges as tight as possible.

Attached Files

AVERAGE(IF(_.xlsx (18.0 KB, 20 views)

« 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 08:16 AM.