Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have a spreadsheet with data that I wish to sum up just two columns (A and
K cols). I need to filter column "A"( that column list names of items which can be repeated in any order), and totals in column "K". I'm looking for a vb code that will insert a summing sheet with the list of items in one column and there totals in another, and then product a bar chart. Is tht possible? -- ASU |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Have you thought of a pivot table? Try Help and then come back with more
questions. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "ASU" wrote in message ... I have a spreadsheet with data that I wish to sum up just two columns (A and K cols). I need to filter column "A"( that column list names of items which can be repeated in any order), and totals in column "K". I'm looking for a vb code that will insert a summing sheet with the list of items in one column and there totals in another, and then product a bar chart. Is tht possible? -- ASU |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
summing values appearing in col B when col A has been filtered | Excel Worksheet Functions | |||
Summing a Range Omitting the Occasional #N/A | Excel Worksheet Functions | |||
Summing cells in pivot tables | Excel Discussion (Misc queries) | |||
Cumulative Summing | Excel Discussion (Misc queries) | |||
Summing Formula | Excel Worksheet Functions |