# Max; Min & Dates

R

My spreadsheet has dates in Column A and data in columns B-S all relating to
shipments. Column P contains weights. What I am trying to do get Max & Min
for specific time frames. The Max formula
=MAX(--(MONTH(A\$3:A\$88)=1)*P\$3\$88) using CSE seems to work but the Min
returns blanks. Data exists in rows 3 - 30 only. I am keeping the
spreadsheet open as I add at least three shipments per week. Any suggestions?

Thanks,

Ron

×

#### ×ž×™×›××œ (×ž×™×§×™) ××‘×™×“×Ÿ

The principal is shown in the attached picture.
http://img705.imageshack.us/img705/3079/nonameaw.png
*** These are array formula, and are to be confirmed with CTRL+SHIFT+ENTER
rather than with simply ENTER.
The curly brackets {} are not to be typed manually, those are entered by the
â€œExcelâ€, when the formula is entered as an Array formula.
Micky

×

#### ×ž×™×›××œ (×ž×™×§×™) ××‘×™×“×Ÿ

The MIN Formula can also be:
{=MIN(IF((MONTH(A\$1:A\$25)=1)*(B\$1:B\$25)<>0,(MONTH(A\$1:A\$25)=1)*(B\$1:B\$25)))}
Micky