Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FILTERING RESULTS
I HAVE A LIST OF NAMES AND VALUES AND I WANT TO FILTER THE TOTALS ON A
SEPARATE SPREADSHEET. IN OTHER WORDS EVERY TIME I LIST A NAME WITH AN AMOUNT IT WILL PUT THE AMOUNT INTO THE CORRESPONDING NAMES RUNNING TOTAL |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FILTERING RESULTS
Just open both spreadsheets at the same time click on the cell that you want
the running total to go in, click the auto sum button, switch spreadsheets and select the range from which you wish to obtain the total. if the range is in separate chunks hold down ctrl while selecting the ranges. "MIKEZ" wrote: I HAVE A LIST OF NAMES AND VALUES AND I WANT TO FILTER THE TOTALS ON A SEPARATE SPREADSHEET. IN OTHER WORDS EVERY TIME I LIST A NAME WITH AN AMOUNT IT WILL PUT THE AMOUNT INTO THE CORRESPONDING NAMES RUNNING TOTAL |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FILTERING RESULTS
With data arranged as below
Sheet1!ColA contains names Sheet1!ColB contains amount 'If you mean a total of the amount from..The below formula in Sheet2 =SUM(Sheet1!B:B) 'If you mean a total of the amount for a particular name say 'Mikez' =SUMIF(Sheet1!A:A,"mikez",Sheet1!B:B) OR With Mikez in Sheet2 cell A1 ;try the below formula in cell B1 =SUMIF(Sheet1!A:A,A1,Sheet1!B:B) If this post helps click Yes --------------- Jacob Skaria "MIKEZ" wrote: I HAVE A LIST OF NAMES AND VALUES AND I WANT TO FILTER THE TOTALS ON A SEPARATE SPREADSHEET. IN OTHER WORDS EVERY TIME I LIST A NAME WITH AN AMOUNT IT WILL PUT THE AMOUNT INTO THE CORRESPONDING NAMES RUNNING TOTAL |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FILTERING RESULTS
Jacob take a look at "a macro with finishing criteria" question posted in
general questions! One of your subs is "bright and quick to handle" Nice! "Jacob Skaria" wrote: With data arranged as below Sheet1!ColA contains names Sheet1!ColB contains amount 'If you mean a total of the amount from..The below formula in Sheet2 =SUM(Sheet1!B:B) 'If you mean a total of the amount for a particular name say 'Mikez' =SUMIF(Sheet1!A:A,"mikez",Sheet1!B:B) OR With Mikez in Sheet2 cell A1 ;try the below formula in cell B1 =SUMIF(Sheet1!A:A,A1,Sheet1!B:B) If this post helps click Yes --------------- Jacob Skaria "MIKEZ" wrote: I HAVE A LIST OF NAMES AND VALUES AND I WANT TO FILTER THE TOTALS ON A SEPARATE SPREADSHEET. IN OTHER WORDS EVERY TIME I LIST A NAME WITH AN AMOUNT IT WILL PUT THE AMOUNT INTO THE CORRESPONDING NAMES RUNNING TOTAL |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FILTERING RESULTS
Hi "Atishoo"
Thanks for the feedback.. I have responded to that post and thank you very much for pointing that out. If this post helps click Yes --------------- Jacob Skaria "Atishoo" wrote: Jacob take a look at "a macro with finishing criteria" question posted in general questions! One of your subs is "bright and quick to handle" Nice! "Jacob Skaria" wrote: With data arranged as below Sheet1!ColA contains names Sheet1!ColB contains amount 'If you mean a total of the amount from..The below formula in Sheet2 =SUM(Sheet1!B:B) 'If you mean a total of the amount for a particular name say 'Mikez' =SUMIF(Sheet1!A:A,"mikez",Sheet1!B:B) OR With Mikez in Sheet2 cell A1 ;try the below formula in cell B1 =SUMIF(Sheet1!A:A,A1,Sheet1!B:B) If this post helps click Yes --------------- Jacob Skaria "MIKEZ" wrote: I HAVE A LIST OF NAMES AND VALUES AND I WANT TO FILTER THE TOTALS ON A SEPARATE SPREADSHEET. IN OTHER WORDS EVERY TIME I LIST A NAME WITH AN AMOUNT IT WILL PUT THE AMOUNT INTO THE CORRESPONDING NAMES RUNNING TOTAL |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FILTERING RESULTS
NP i loved the english "bright and quick to handle"
"Jacob Skaria" wrote: Hi "Atishoo" Thanks for the feedback.. I have responded to that post and thank you very much for pointing that out. If this post helps click Yes --------------- Jacob Skaria "Atishoo" wrote: Jacob take a look at "a macro with finishing criteria" question posted in general questions! One of your subs is "bright and quick to handle" Nice! "Jacob Skaria" wrote: With data arranged as below Sheet1!ColA contains names Sheet1!ColB contains amount 'If you mean a total of the amount from..The below formula in Sheet2 =SUM(Sheet1!B:B) 'If you mean a total of the amount for a particular name say 'Mikez' =SUMIF(Sheet1!A:A,"mikez",Sheet1!B:B) OR With Mikez in Sheet2 cell A1 ;try the below formula in cell B1 =SUMIF(Sheet1!A:A,A1,Sheet1!B:B) If this post helps click Yes --------------- Jacob Skaria "MIKEZ" wrote: I HAVE A LIST OF NAMES AND VALUES AND I WANT TO FILTER THE TOTALS ON A SEPARATE SPREADSHEET. IN OTHER WORDS EVERY TIME I LIST A NAME WITH AN AMOUNT IT WILL PUT THE AMOUNT INTO THE CORRESPONDING NAMES RUNNING TOTAL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting no results from Advanced Filtering in Excel 2007 | Excel Discussion (Misc queries) | |||
Filtering results | Excel Discussion (Misc queries) | |||
filtering results to another sheet | Excel Discussion (Misc queries) | |||
sorting and filtering results | Excel Worksheet Functions | |||
display count/results of filtering Excel in status bar | Excel Discussion (Misc queries) |