| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find the cell ID of last row in the column and use it in SUMIF for
Hi,
I have this formula to find the cell ID of the last row in a column: =ADDRESS(MATCH(9.99999999999999E+307,'IT hours'!A:A),1) eg.. if the result is $A$933 I want to use this Cell ID in a SUMIF formula. SUMIFS('IT Ratio'!$A$4:$A$933,'IT Ratio'!$A$4:$A$118,'For SLR'!E$17,.....) ie. to replace the $A$933 in the formula, so that the sumifs will work dynamically. May I know what should be the syntax for this? Appreciate any help. Thanks, YY. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
| Find max value in one column and return the value of corrosponding cell in different column | Excel Worksheet Functions | |||
| find first empty cell in column and start transpose next row in that cell | Excel Discussion (Misc queries) | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Using SUMIF and FIND/RIGHT to add values of a partial cell referen | Excel Discussion (Misc queries) | |||
![YY san.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
