Forum Discussion
Subtotal If
Hello! I have created a sumif formula that allows me to calculate the total hours my day's todo list will take me. For my work excel I have a list of things to do and what days I plan to complete t...
=SUMIF(D93:F137,H2,F93:F137)
Example in the file
Hope I was able to help you with this info.
NikolinoDE
- Hi NikolinoDE!
Unfortunately, that didn't subtract the filtered values from the subtotal like I would want. It did sum, but I want the formula to subtract the values I filter once they are "complete" as well.
Thank you though!!Hope I got it right now :))
= SUBTOTAL( 109,F5:F137)
Example in the inserted file
Thank you for your understanding and patience
NikolinoDE
I know I don't know anything (Socrates)
