Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum in another cell with reference to another
I need to add cells which only have reference to another eg:
PNS Kilbirnie 2.0 NW Newtown 1.0 NW Island Bay 1.5 NW Metro 1.0 PNS Kilbirnie 1.0 eg: Need to add only the "PNS Kilbirnie" totals but these are also in other columns similar to above. At the moment these two columns are A & B, then I need to also add the Kilbirnie from column C & D as per above -- Shirl, NZ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |