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

C

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?
 
G

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
 
C

co_jer

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

Gary''s Student

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of Price Given Specific Dates 2
SUM Range based on date 7
Conditional Sum in Array with wild card and between dates 3
Averaging two ranges on the same column (excluding zeros) 2
Using SUMIF to add data between a range of dates 2
SUMIFS Between dates that are greater than zero 1
Sumif withdates 2
Sum a range based on another range of cells 8

Top