formula to find 2 or more criterias then average the sum

		Microsoft Office Forums > Microsoft Excel > Excel
formula to find 2 or more criterias then average the sum

FAQ

Thread Tools

Display Modes

02-11-2014, 06:15 AM

samtitus

Windows XP formula to find 2 or more criterias then average the sum

Office 2007

Novice

Join Date: Feb 2014

Location: Johannesburg, South Africa

Posts: 4

formula to find 2 or more criterias then average the sum

I need a formula to do the following look up a name in column A1 on sheet1 then look up that name on sheet2 in column A1:A6 when it finds that name it need to look in column B to find a date, if that date matches January 2014 it has to look up the value in column c and average all the values it finds for that person in January 2014

PLEASE THIS IS URGENT

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge to print specific record based on mergefield criterias	nicnad	Mail Merge	1	02-22-2012 01:53 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
Find duplicates formula	hannu	Excel	2	10-26-2010 02:48 AM
Needs help to find excel formula- Please	aamer_1983	Excel	2	07-13-2009 01:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:09 PM.