| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row function
Hi All!
I am using the following formula to add totals on a sheet named Apps. & Invs. =SUMPRODUCT(SUBTOTAL(9;OFFSET('Apps. & Invs.'!I$1;ROW('Apps. & Invs.'!I$2:OFFSET('Apps. & Invs.'!I54;;))-1;))*('Apps. & Invs.'!H$2:OFFSET('Apps. & Invs.'!H54;;)="ord.")) I entered the I54 and H54 references myself but in fact I would like these to be the last cell on each column. Can someone help me correct this! Also I've read the Row() explanations on excel help but cannot understand what it equates to in this example...any explanations are very welcome! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Threaded Mode
