Hi

Something like this:
=IF(X1="Count",COUNT(A2:A10),IF(X1="Sum",SUM(A2:A1 0),IF(X1="Average",AVERAGE
(A2:A10),"")))

You can define subformulas as named ranges
fCnt=COUNT($A$2:$A$10)
fSum=SUM($A$2:$A$10)
fAvg=AVERAGE($A$2:$A$10)
now you can have the formula
=IF(X1="Count",fCnt,IF(X1="Sum",fSum,IF(X1="Averag e",fAvg,"")))


--
Arvi Laanemets
(Don't use my reply address - it's spam-trap)


wrote in message
...
Hello great folks who have saved me more than once:

I have a data validation list (drop down list) in one
cell, which offers a choice of 3 different selections; in
the next cell I have a formula (would like to have a
formula for each validation). Is it possible to create a
formula that says if this is chosen in the data validation
box, use this formula, if something else is chosen from
the drop down box use another formula, etc? Thus, a
different formula for each choice in the validation list.
Thank you in advance