Home 
Search 
Today's Posts 
#1




summing values appearing in col B when col A has been filtered
In sheet 1 I have two columns: Column A has a list of 10 entries of 4 different people, randomly repeating. (Bob, Sally, Bob, Dave, Sarah, Sally, Sarah, Bob, Sally, Bob) Column B has random values for each entry (10, 13, 50, 56, 100, 250, 20, 35, 60, 25) I have applied the autofilter so that I am able to see the 'values' for each person. In sheet 2 I have two columns: Column A with 4 entries of the 4 people sheet 1 is concerned with. (Bob, Sally, Dave, Sarah) In column B of sheet 2, I want totals to appear for each person by summing the values that appear for each in sheet 1. (i.e. 120 for Bob) I'm thinking it's got something to do with vlookup but that's as far as i got! Any help is much appreciated! Thanks  choc_penguin  choc_penguin's Profile: http://www.excelforum.com/member.php...o&userid=30099 View this thread: http://www.excelforum.com/showthread...hreadid=507936 
#2




summing values appearing in col B when col A has been filtered
You want to sum using one criteria, so SUMIF can be used here  in B1
of Sheet 2 enter this formula: =SUMIF('Sheet 1'!A1:A10,A1,'Sheet 1'!B1:B10) Copy the formula into B2 to B4. Hope this helps. Pete 
#3




summing values appearing in col B when col A has been filtered
Was just about to reply saying I'd figured it out but Thanks for your reply!  choc_penguin  choc_penguin's Profile: http://www.excelforum.com/member.php...o&userid=30099 View this thread: http://www.excelforum.com/showthread...hreadid=507936 
#4




summing values appearing in col B when col A has been filtered
=SUMPRODUCT((Data!$A$1:$A$10=A38),(Data!$B$1:$B$10))
Change Data to Sheet1  Kevin Vaughn "choc_penguin" wrote: In sheet 1 I have two columns: Column A has a list of 10 entries of 4 different people, randomly repeating. (Bob, Sally, Bob, Dave, Sarah, Sally, Sarah, Bob, Sally, Bob) Column B has random values for each entry (10, 13, 50, 56, 100, 250, 20, 35, 60, 25) I have applied the autofilter so that I am able to see the 'values' for each person. In sheet 2 I have two columns: Column A with 4 entries of the 4 people sheet 1 is concerned with. (Bob, Sally, Dave, Sarah) In column B of sheet 2, I want totals to appear for each person by summing the values that appear for each in sheet 1. (i.e. 120 for Bob) I'm thinking it's got something to do with vlookup but that's as far as i got! Any help is much appreciated! Thanks  choc_penguin  choc_penguin's Profile: http://www.excelforum.com/member.php...o&userid=30099 View this thread: http://www.excelforum.com/showthread...hreadid=507936 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Count Unique Values In A Filtered Row with Duplicates  Excel Discussion (Misc queries)  
Positioning Numeric Values Resulting from 6 Column Array Formula  Excel Worksheet Functions  
Summing values if conditions are true  Excel Worksheet Functions  
What is the best method for summing values where you want 2 value.  Excel Discussion (Misc queries)  
Second serie doesn't use Xas values  Charts and Charting in Excel 