Thread: Multiple Filter?
View Single Post
 
Old 12-19-2017, 08:35 AM
ProudLiberal's Avatar
ProudLiberal ProudLiberal is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Jun 2017
Location: suburban Chicago
Posts: 28
ProudLiberal is on a distinguished road
Default
Here are a couple of different approaches to your question. (see attached sample file)

FILTER TAB: uses filters in column A and subtotals for TOTAL formula

SUMIF TAB: uses X in column C and sumif for TOTAL formula
Attached Images
File Type: jpg Yogurt Options.jpg (51.8 KB, 21 views)
Attached Files
File Type: xlsx Yogurth Options.xlsx (13.1 KB, 12 views)
Reply With Quote