| 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 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 | |||
Hybrid Mode
