Thread: Sumifs in Excel 2007 for only numerical values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tigerxxx Tigerxxx is offline
external usenet poster
  
Posts: 78
Default Sumifs in Excel 2007 for only numerical values
Hello,

How can I write a "Sumifs" formula in Excel 2007 which sums only if the
range of a criteria contains numbers?
Example: if sum cells b2:b8 only if cells a2:a8 contain numbers.

Thank you


Reply With QuoteReply With Quote