How does one get excel sum of a column based on given dates range

[co_jer]

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?

 

[Gary''s Student]

Here is the first part. Say the dates are in column A and the values are in
column B. Then:
=SUMPRODUCT((A1:A100>DATE(2008,3,12))*(A1:A100<DATE(2008,3,24)),(B1:B100))

will give the sum of the values between 3/13/2008 and 3/23/2008

 

[co_jer]

Gary"s student. Partial solution is better than none! I wil give it a try.
Thanks much.

 

[Gary''s Student]

If it is possible, convert the zeros into blanks. AVERAGE() will ignore blanks