Can I use a SUMIF formula to sum children rows?
Looking for help on writing a formula to be located in the Parent Row under the Forecast column Row 1 to sum children rows of all Salesperson except Mike.
I manually entered a formula =Value2 + Value3 + Value 5 in the Parent Row (90% Closing) Forecast column Row 1 to get the sum total of $700,000 that I am looking for, but want a formula to automatically calculate the total Forecast except for Salesperson Mike when I add more children rows under the 90% Parent Row.
Is SUMIF the way to go?
Help Article Resources
Check out the Formula Handbook template!