| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change the number of rows to a variable
Now, the number of rows in 'Data' sheet is 3938, so the function is: =SUMPRODUCT((Data!G2:G3938=7100)*(Data!B2:B3938=10 00)*(Data!O2:O3938=2)*(Data!C2:C3938) If I don't know the number of rows is 3938, what should I do t accomplish the same function -- minrufen ----------------------------------------------------------------------- minrufeng's Profile: http://www.excelforum.com/member.php...fo&userid=2620 View this thread: http://www.excelforum.com/showthread.php?threadid=39592 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change the number of rows to a variable
Use: ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastC ell).Row This returns the number of the last used row in a worksheet -- Raman325 ------------------------------------------------------------------------ Raman325's Profile: http://www.excelforum.com/member.php...o&userid=24748 View this thread: http://www.excelforum.com/showthread...hreadid=395920 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change the number of rows to a variable
How to combine this into the sumproduct function in the original post? Thanks for your help. Raman325 Wrote: Use: ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastC ell).Row This returns the number of the last used row in a worksheet -- minrufeng ------------------------------------------------------------------------ minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208 View this thread: http://www.excelforum.com/showthread...hreadid=395920 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing a variable number of rows | Excel Discussion (Misc queries) | |||
| copy down with variable number of rows | Excel Discussion (Misc queries) | |||
| change the number of rows to a variable | Excel Programming | |||
| Paste to variable number of rows | Excel Programming | |||
| deleting variable number of rows | Excel Programming | |||
![minrufeng[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
