| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to use sumif to sum up a column based on a range of dates | Excel Worksheet Functions | |||
| Excel 2007 Display value based on values in another column range | Excel Worksheet Functions | |||
| Lookup based on range of dates | Excel Worksheet Functions | |||
| return based on range of dates | Excel Worksheet Functions | |||
| EXCEL Sum column based on time range in different column? | Excel Worksheet Functions | |||
Linear Mode
