Hello all and thanks in advance. In Column W, I want excel to take the date in column R and find it in column G. Then, I want it to average all of the numbers that are found in column K. I've looked online using Google but have found no answers. Not sure if I need to use an "IF(Vlookup), SUMPRODUCT or something else.
Thanks!
Best,
LouisSumproduct.PNG
Actually, it sounds like you may want to look at using AVERAGEIF()Not sure if I need to use an "IF(Vlookup), SUMPRODUCT or something else.
However, please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
Last edited by FDibbins; 01-31-2015 at 09:50 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hello,
45 days to expiration SPX Upload to Forum.xlsx
Sorry about that. Wasn't sure what the preferred method for the forum was. Please find attached and thank you!
Cheers,
Louis
This is the formula you would use...
=AVERAGEIF($G$4:$G$245,R4,$K$4:$K$245)
However, none of your dates in G match any of your dates in R. G is all 1996, and R is 2014 and 2015?
Ha ha ha. Thanks FDibbins! The data goes on for 45k rows below.
Respect.
Louis
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks