I 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!
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.