if search formula incl date range
What I have working so far:
=IF(C2="MCD",MIN(IF($D$2:$D$13="1001",$B$2:$B$13)) ," ")
When I try to add an AND statement to make the min calculate on rows that
meet 2 criteria, it's not working:
=IF(C4="MCD",MIN(IF(AND($D$2:$D$13="1001",$C$2:$C$ 13="Private"),$B$2:$B$13))," ")
"Laury" wrote:
Oops - forgot a criteria:
If the type in row 1 = X, find the minimum $Amt from all the rows where
Type=Y or Z, AND Date is within 30 days of the Date in row 1, ONLY SEARCHING
the rows where the Text Code is equal to the Text Code in row 1.
"Laury" wrote:
I need to write a formula to do the following and it's just feeling way over
my head. I know I need an "if" at the beginning but then I get lost. Can
anyone help?
Col A Col B Col C Col D
Date $Amt Type Text Code
If the type in row 1 = X, find the minimum $Amt from all the rows where
Type=Y or Z, AND Date is within 30 days of the Date in row 1.
|