Formula to calculate the difference between two numbers based on a month in another column

Chevon Brownell

I am unsure if it is possible to do what I want, but I wanted to ask. I have attached a copy of my grid. I want a formula to calculate the difference between the largest and smallest numbers for each well for each month. For example, for well #2 in month one, find the largest number (58650300) and subtract the smallest number (58526600) to give me the total produced in the month. Then, repeat this for each well and each month. I need this formula to be used year after year, so I need it based on month and not date specific.

Weekly Well Readings.xlsx

Paul Newcome

Where will these formulas live? Are you able to provide a screenshot of a manually created example of what you are wanting to accomplish?

Chevon Brownell

I am unsure if the formulas can be incorporated into the sheet summary option in this sheet or if they need to be on a separate sheet. I am looking for any and all advice and help. I have yet to try to put a formula together. I only know what results I am looking for. I tried to explain it in my question.

Paul Newcome

 Are you able to provide a screenshot of a manually created example of what you are wanting to accomplish? "Every well for each month" could mean a couple of different things. Do you mean current month, or do you intend to have separate fields for Well A - Jan 2024, Well A - Feb 2024, Well B - Jan 2024, Well B - Feb 2024, etc.?

Chevon Brownell

Yes, I am trying to come up with a formula that will calculate the amount for each month for each well. My crew gets weekly readings and enters them into the grid, and I was looking for a way to quickly calculate how much it changes from the month's first reading to the last. Does that help explain it more?

Paul Newcome

Yes. Definitely. Next question would be… Will you have multiple years in the source data so that (for example) for January, we need to specify Jan 2024 vs Jan 2025? Or would you want current year? Or some other logic if necessary?

Chevon Brownell

I plan to clear out the grid each year, so the calculations should be based on month rather than year, if possible.