I have a Sheet that has my "Well Names" in Column A then Production Data on the rest of the sheet. I am can not figure out how to set up a counting formula that will add up the number times a well name is listed. I know a counting formula can be done but my problem comes when I also need it to add that count to the day number that that well starts at.
Example "Well 1" Production days starts at -56 and "Well 2" Starts on -45. Now on each production day that I download I need it to count up the number of times "Well 1" is listed then add it to the -56 or whatever day number the well started with.
Hope I am making since - To much coffe and not enough sleep this morning
Example "Well 1" Production days starts at -56 and "Well 2" Starts on -45. Now on each production day that I download I need it to count up the number of times "Well 1" is listed then add it to the -56 or whatever day number the well started with.
Hope I am making since - To much coffe and not enough sleep this morning
