hi guys
in cell ac30 im looking to return the average of column L IF column c is matched by whats in cell B2 and if column b falls between dates of 07/08/14 and 20/07/16
would appreciate any help
hi guys
in cell ac30 im looking to return the average of column L IF column c is matched by whats in cell B2 and if column b falls between dates of 07/08/14 and 20/07/16
would appreciate any help
Sounds like you just need to use AVERAGEIF with three criteria; C2:Cx, $B$2, date >= start date, and date <= end date.
Suggest you post a sample workbook so we can see the data layout and have something to test with.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
You may have to adjust the ranges that this formula applies to based on your actual dataset. I assumed your data you're matching in columns B, C, and L starts in row 30 and goes to row 66. Once you adjust the ranges to fit what your data, this solution should work.
Let me know if that works for you!Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks