Thread: Multiple cell reference IF function
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default Multiple cell reference IF function
"Roger Govier" wrote:
.. =IF(COUNTA(Mydata)<12,"You need more data",SUM(Mydata))

Nice, neat solution, Roger !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote