Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combined histograms in single sheet
Hi
I have a wb with 5 spreadsheets. Each spreadsheet has 2 columns: parameter and frequency. The individual spreadsheets consist of histograms stacked on top of each other vertically - ie: Argentina 1 Argentina 3 Argentina 3 Argentina 5 Australia 13 Australia 17 Australia 14 Australia 17 Australia 22 Austria 1 Austria 4 Austria 8 Austria 3 Austria 6 Belgium 6 Belgium 1 Belgium 7 Brazil 7 Brazil 6 Brazil 10 Brazil 13 Brazil 9 Bulgaria 1 Canada 48 Canada 52 Canada 38 Canada 55 Canada 59 I need to get it into the form: Canada 252 (sum of 48, 52,38,55,59) Brazil 45 (sum of 7, 6, 10,13, 9) I have tried with Vlookup and several other methods without success. Thanks in advance! CLSnyder |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combined use - drop-downs, filters, protect sheet | Excel Worksheet Functions | |||
lookup single value in one sheet, return multiple results from theother sheet | Excel Worksheet Functions | |||
Histograms | Excel Discussion (Misc queries) | |||
How to break out data combined in a single cell | Excel Worksheet Functions | |||
is it possible to use F9 to manually calculate in a single sheet or single workbook? | Excel Discussion (Misc queries) |