Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() "Steve W" ha scritto nel messaggio ... Can someone please suggest a formula for summing the contents in a row - for a range consisting of the 12 columns immediately to the left of a specified column in that row -- Ciao Steve, I think you can use: =SUM(INDIRECT("rc[-12]:rc[-1]",FALSE)) That you can put in a reference to a definited name (es: sum12) so you can use in worksheet =sum12 Or you can change style to reference from A1 to R1C1 ed use: =SUM(rc[-12]:rc[-1]) ivano |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Cannot change a formula | Excel Discussion (Misc queries) | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |