Thread: Summing
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Summing

Rick wrote:
I made a typo below which changed the description of what I am
trying to do. A14 needs the highest value from either A1 or the
sum of A2:A13


I am glad you clarified that. Your first posting made no sense to me.
Try:

=if(isblank(A1), "", max(A1, sum(A2:A13)))