Forum Discussion
kayleehansen
Aug 29, 2021Copper Contributor
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...
kayleehansen
Aug 30, 2021Copper Contributor
Thank you so much!
I am receiving an error message and it is not inputting a number when I press enter. Is there something else I should try?
Thank you!
HansVogelaar
Aug 30, 2021MVP
Here is the workbook with the formulas (I expanded the ranges).
- kayleehansenSep 24, 2021Copper Contributor
That was very helpful! However, I am still receiving an #VALUE! when I copy it to my personal excel. I have attached the document and really appreciate all your help!
- RShaw1972Oct 24, 2023Copper ContributorHi kayleehansen. Were you able to get past the #VALUE! error? I get the same error and NikolinoDE's solution isn't working.