View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
HKaplan HKaplan is offline
external usenet poster
 
Posts: 80
Default Addition & multiplication formula

Why the complicated formula?

=sum(F8:F26) will return 0 if F8:F26 is empty anyway. You don't need
to test for cells with data.