View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Michael Link
 
Posts: n/a
Default Ignoring Dates in Sums

Thanks! The two replies I've gotten have clarified things quite a bit--though
working with dates in Excel always strikes me as a bit complex. Thanks again!

"Pete_UK" wrote:

The problem is that to Excel a date is just a number, so how could you
exclude one number and not another?

Numbers that represent recent dates are all in the 38,000 range (eg
today is 38811), so if the other numbers are very much lower than this,
then you could make use of this to exclude the dates, eg something
like:

=SUMIF(A1:A1000,"<"35000,A1:A1000)

if the column with the mixed data is A.

Hope this helps.

Pete