I have a spreadsheet and I need to have formulas that will check column A
for a specific customer and if it is the specific customer, I need it to look
at column F and give me the average, median, total, min, and max items
ordered. I am trying to use array formulas and the max and total formulas
work, but the other three do not. Could you tell me what I may be doing
wrong? Here are the two array formulas that work.
=MAX((DataEntry!$A$4:$A$2000=$A5)*DataEntry!$F$4:$ F$2000)
=SUM((DataEntry!$A$4:$A$2000=$A5)*DataEntry!$F$4:$ F$2000)
Any help you can give me would be appreciated.
Betsy"