| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Growing range within a Sumproduct.
I am keepting track of all the calls i get so the range changes daily. In A
is the date and column J is who took the call. Is there any way to take this formula and have it refer to one place for the range end as my table grows? =SUMPRODUCT((MONTH(Data!$A$5:$A$670)=MONTH($A25))* (YEAR(Data!$A$5:$A$670) =YEAR($A25))*(Data!$J$5:$J$670=C$18)) Thanks. -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumProduct with criteria list | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Using a worksheet name from a range | Excel Worksheet Functions | |||
| Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
| sumproduct in a range | Excel Worksheet Functions | |||
Threaded Mode
