April 25, 2022
Would just like to ask on what would the IF and sum formula to use on this.
On a separate sheet, I need to sum all the Complete and Incomplete figures but per region.
Below would be the output, though was wondering what would be the formula to do this instead of manual approach. Appreciate your help. Thanks.
October 5, 2010
You should do this with a Pivot Table - it will do the sum calculations automatically for you
You can do it with SUMIF but it is more labourious, I wouldn't recommend it.
Check the attached file for examples of both the Pivot Table and SUMIF approaches.