View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SirMatthew SirMatthew is offline
external usenet poster
 
Posts: 8
Default Exclude dates from a sum formula

I have a spreadsheet, several, actually, that have columns containing both
numbers and dates. I want to add accross the colums, but exclude the dates.
I didn't realize that it was adding the numeric value of the dates in my end
formula, and I don't want to have to do the +c12+e12+g12, etc. Any thoughts
on making this easier? I tried storing the dates as text, and that seems to
be OK but the stupid error checking is driving me NUTS! I would like to have
them formatted as dates, just not included.

Thanks!