I need help trying to figure out how to make a formula that will create a subtotal (sum) that will only add visible fields when using filter.
What I need it to do is: Create a subtotal of all values from column C (Span Code) when column B (Span Type) is not "Manual - Climbing", then take all values that ARE "Manual - Climbing", add them together and multiply them by 3, and add them to the first total.
All while not adding rows that are filtered out by the company column A.
I've been able to create partial formulas using SUMIFS, but they don't work with filtered data... Is there any way to do this?
So basically, (sum spantype <> Manual) + (sum spantype = Manual, subtotal *3) in case I wasn't clear. xD
Bookmarks