Results 1 to 6 of 6

Picking out average minimum values controlled by 2 different variables

Threaded View

  1. #1
    Registered User
    Join Date
    10-28-2022
    Location
    Uppsala
    MS-Off Ver
    MS365 2209
    Posts
    3

    Picking out average minimum values controlled by 2 different variables

    Hi, I am designing a hydrology sheet where you put in average discharge values from time series and then get the results from different parameters, I am not very experienced in excel though. The time series shows discharge values for every day in ten years.

    Now, I want to calculate average minimum value for every MONTH in the time series.
    Ideal would be a formula that picks out the minimum value for all january MONTHS for all YEARS in the time series and then calculate the average value out of those.

    However I am uncertain how to do this, and since I have a lot of columns in the sheet I would like to avoid adding too many columns, the ideal would be if the formula could just use the existing columns without the need to create new columns with data of minimum values for every single month or similar.

    Now, I want to calculate average minimum value for the month of january in the time series.

    Currently, my formula looks like this:

    =MIN(FILTER($E$78:$E$4095;COUNTIF(C63;$I$78:$I$4095)))

    Where
    E = Discharge values from time series
    C = The actual month I want to know the minimum value of
    I = Month for corresponding discharge value in the time series

    so...
    =MIN(FILTER($"values from time series";COUNTIF("month of interest";"corresponding months in time series")))

    Besides the mentioned columns/variables; I also have a column with the current year in the time series.

    The problem with my formula is that it picks out of the minimum value for ALL january months together in the time series, when I want to know the AVERAGE minimum value for the month of january.

    Can I solve this problem by just changing my formula, without creating a lot of columns with new data?
    Simplified excel example sheet for modification is attached. (the formula should handle much longer data series and be used for all months in the actual sheet)


    I also add a picture of my actual excel sheet to provide information about how much data is actually in the sheet if it helps but I think the description above probably describes my problem better.
    excelproblem.jpg
    Attached Files Attached Files
    Last edited by Eastby91; 10-28-2022 at 05:34 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Solver: minimum value of two variables that result in x
    By mucura in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 02-03-2022, 07:37 AM
  2. Chart Template Not Picking All Variables
    By Excel-Access in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-08-2019, 06:58 PM
  3. Picking Closest Date from List - With Date Minimum
    By JPolvCB in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-05-2013, 12:55 AM
  4. calculate average from an array with controlled length
    By Christopher83 in forum Excel General
    Replies: 7
    Last Post: 02-07-2012, 06:06 AM
  5. Picking more than one minimum value from a column
    By vkartikv in forum Excel General
    Replies: 4
    Last Post: 09-06-2011, 06:21 PM
  6. How to calculate the average of minimum values
    By gideone in forum Excel General
    Replies: 9
    Last Post: 08-31-2011, 03:56 AM
  7. Finding a minimum with solver and 3 variables
    By BCITgirl in forum Excel General
    Replies: 2
    Last Post: 12-05-2010, 05:16 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1