Apache OpenOffice Community Forum

One more question if I may, How would I find the Min and also the Max for 4 weeks back using a similar calculation (instead of averaging)? This would be in the M and N columns.

opog wrote:How would I find the Min and also the Max for 4 weeks back using a similar calculation (instead of averaging)? This would be in the M and N columns.

Your previous topic (about AVERAGE) was solved. The SUMPRODUCT technique used for that topic does not apply to MIN or MAX, hence you need a new topic. Using a different approach with four columns to hold intermediate values makes finding all of MIN, MAX, and AVERAGE easy. If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

That's perfect, thanks!