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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 01:48 PM.