min date with if condition

It will probably be a result of the fact that the formula does not refer tot he same range. If you have a blank cell in the date column that corresponds to the value in F2 in the other column, it will return a zero. Are the columns of REALLY of unequal length????

Hi all- @Valeria88, although your formula returns a single result, it processes arrays to arrive at that result. Therefore, it is a single-cell ARRAY FORMULA. Such formulas return incorrect results UNLESS you press CTRL+SHIFT+ENTER after pasting or editing in the Formula Bar. This tells Excel to check for arrays during calculation. If done properly, {} curly braces will appear and enclose your formula, signalling successful array entry.
NOTES:
1) NO, you can't just type the braces in, as that causes Excel to treat the entry as TEXT rather than a formula.
2) To copy a ARRAY FORMULA to other cells, either "drag" it, or select a SEPARATE paste area that does not include the copied cell.

Guidelines-and-examples-of-array-formulas

Oh. Thanks leelnich. i forgot to add my canned "array formula" response.

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

MIN may return zero in this case, either if nothing matches or the dates are text formatted. For debugging what result do you get with this formula?

=SUMPRODUCT(('Overall Data'!$S:$S=Help!$F$2)+0,'Overall Data'!$C$:$C)

The root cause of your problem is that the formula in S returns "6.17 " formatted as text, with a training space. it's probably better to get rid of the trailing space, rather than taking it into account. So, modify the formula in S to:

=IFERROR(TRIM(MID(E2,FIND(".17 ",E2)-1,5))+0,0)

and then use the array formula:

=MIN(IF('overall data'!$S$2:$S$12000=help!$F$2,'overall data'!$C$2:$C$12000))

to return the desired result. Alternatively, modify column S and use this ordinary formula:

=AGGREGATE(15,6,'overall data'!$C$2:$C$12000/('overall data'!$S$2:$S$12000=help!$F$2),1)

You're welcome.

Hi all. You could also skip column S altogether. In help!H2:

Please Login or Register  to view this content.

...and in H3:

Please Login or Register  to view this content.