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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum in another cell with reference to another
One way to get this delivered in 10 secs. Do a 5 sec copy/paste stack up of
the data in cols C & D below that in col A & B, then create a pivot on the combined data, placing the col A's header into ROW, col B's header into DATA (set to Sum). That's it, all done in 10 secs or so. The pivot will return the unique listing of items in col A with their corresponding sums adjacent to it. Any joy? hit YES below -- Max Singapore --- "Shirl" wrote: 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 |
Reply |
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 |