View Single Post
 
Old 02-11-2014, 06:15 AM
samtitus samtitus is offline Windows XP Office 2007
Novice
 
Join Date: Feb 2014
Location: Johannesburg, South Africa
Posts: 4
samtitus is on a distinguished road
Angry 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
Reply With Quote