Thread: I need a formula in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default I need a formula in excel
The SUM function ignores text...

=SUM(A2:A10)

Hope this helps!

In article ,
dlb wrote:

Formula that sums only the numbers in a range and ignores text
Reply With QuoteReply With Quote