Min IF Max IF Multiple Criteria

[GB]

Hi,
for some reason I can't get this simple MIN IF & MAX IF formula to work.

The MIN IF formula I have attempted is to look for all dates in Column A that are between 2 dates then return the min value from column B. I have also done the same for the MAX IF. See attached in cell G3 and H3.

Can you show me the correct way of solving this.
regards
GB

 

[Mike H..]

Hi,
for some reason I can't get this simple MIN IF & MAX IF formula to work.

The MIN IF formula I have attempted is to look for all dates in Column A that are between 2 dates then return the min value from column B. I have also done the same for the MAX IF. See attached in cell G3 and H3.

Can you show me the correct way of solving this.
regards
GB

See your file

 

[GB]

Hi Mike,
thanks for your attempt but it is not what I am trying to resolve. For example in cell G3 I want to search for all dates between F3:F2 from column A then return the minimum value from column B within this data range.
regards
GB

 

[GB]

Hi,
I have just worked it out. For G3 I would use this formula.

=MIN(IF($A$2:$A$72>$F3,IF($A$2:$A$72<$F2,$B$2:$B$72))) with Ctrl Shift Enter.


GB