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?

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

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

will give the sum of the values between 3/13/2008 and 3/23/2008
--
Gary''s Student - gsnu200774


"co_jer" wrote:

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?

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

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

"co_jer" wrote:

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?

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

If it is possible, convert the zeros into blanks. AVERAGE() will ignore blanks
--
Gary''s Student - gsnu200774


"co_jer" wrote:

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

"co_jer" wrote:

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?