Home > Forum Home > Analyzing Corporate Financial Data > Placing filter solutions in spreadsheet Share

Placing filter solutions in spreadsheet

Excel Help for Placing Filter Solutions In Spreadsheet in Analyzing Corporate Financial Data


Forum TopicPost Reply Login

Placing Filter Solutions In Spreadsheet

Rate this:
(3/5 from 1 vote)
ConfusedI am using several filters on a spreadsheet and get the results I want, is there a way to see and paste the formulas that Excel is using into my spreadsheet?

For example, I use Filter for Saturdays only in one column, then filter another column for a person's name.  The count shows up at the bottom of the excel worksheet just fine.  How do I create a formula that does the same thing? I've tried using SUMPRODUCT and the results are close but if a person just works on Saturday we count that as a 1/2, so I can't seem to get a formula that works right. 
I'd be happy to email my test worksheet, too, if that would help understand what I'm trying to do. LOL. Thanks so much for any guidance!

Bill



 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
You could create a separate column with the value for the day - e.g. 0.5 for Saturday etc.  To sum based on the day and person values you could either use a Pivot table with sub and grand totals, or use the SUMIF function (perhaps combined with the AND function) to return the total for matching values in the columns.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Placing filter solutions in spreadsheet in the