Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct (Range unknown, needs Search)
Hello, My current formula down column B is =SUMPRODUCT(--(Sheet1!$A$1:$A$100=TRIM($A1)),(Sheet1!B$1:B$100)) My data in Sheet1 changes regularly so I'd need the ending range to expand or compress depending on where the last row of "Net Income" is situated. For example, if "Net Income" is on row 90; then, the end range should be updated automatically to be $A$1:$A$90 so it doesn't pick up totals past the "Net Income" rows. How do you add a search function so that the $A$100 row changes according to the new row wherever "Net Income" moves to? Thanks, Ricky -- ExcelQuestion ------------------------------------------------------------------------ ExcelQuestion's Profile: http://www.excelforum.com/member.php...o&userid=34059 View this thread: http://www.excelforum.com/showthread...hreadid=538233 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use an index number in a search range | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
how do you search a range of cells... | Excel Discussion (Misc queries) | |||
SUMPRODUCT with date range question | Excel Discussion (Misc queries) | |||
using sumproduct in a range of text fields? | Excel Worksheet Functions |