| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
hi,
select a cell in which you want the sum to be shown.If B2:H2 is to be totalled in A2, put the formula in A2 =sum(B2:H2) K.S.Warrier "Aladin Akyurek" wrote: How do you (intend to) specify the start column? Steve W Wrote: 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 -- Cheers Steve Wilson GISBORNE NZ -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=275162 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Hybrid Mode
