| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM DATA RANGE
Using the below formula as example, is there another formula I can use where
I do not need to put a ending cell to sumproduct. I know I could just put a larger number in, but this formula is getting info from another worksheet that has data entered everyday so it keeps growing. As you can see I have it ending at 2000 but would like it keep formulating without always needing to put the ending cell. =SUMPRODUCT(--(TEXT(Overall!E3:E2000,"mmm/yyyy")=TEXT(C2,"mmm/yyyy")),--(ISNUMBER(SEARCH(A11,Overall!C3:C2000)))) Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
| How do I link data from a horizontal range to a vertical range? | Excel Worksheet Functions | |||
| Show Data In Range not appearing in Separate Range | Excel Discussion (Misc queries) | |||
| How do I change a range name back to the underlying data range? | Excel Worksheet Functions | |||
| Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
Threaded Mode
