View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
co_jer co_jer is offline
external usenet poster
 
Posts: 1
Default How does one get excel sum of a column based on given dates range

in an excel database, there ais one column with multiple dates (some dates
are repeated) and another with related values.

How does one get a sum of related values for a user given date range? What
about averages excluding those with zero values?