| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
function tweak?
Hi there,
I use the following SumProduct formula to search for all values in a specified date range, in this case, for all values in january, then sum those values which fall into that date range: =SUMPRODUCT(--('Daily Reading Master Log'!B3:B400=DATEVALUE("01/01")),--('Daily Reading Master Log'!B3:B400<=DATEVALUE("30/01")),'Daily Reading Master Log'!CB3:CB400) Question: I need to be able to adapt this formula for averaging a set of values for a specified month range. can anyone help me on this? -- Carlee |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need someone to help tweak a code | Excel Discussion (Misc queries) | |||
| VBA File Search Function tweak | Excel Discussion (Misc queries) | |||
| SUMPRODUCT - Tweak | Excel Worksheet Functions | |||
| Array Help Tweak | Excel Worksheet Functions | |||
| Code Tweak | Excel Programming | |||
Threaded Mode
