Thread: summing values appearing in col B when col A has been filtered
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote