Hi I'm looking for some help on a sumif formula in the attached file. I have 4 different categories(1 thru 4) of schedules that I want this formula to add together. A lot of different schedules are listed in column A with their corresponding Category number in B. In Column M, a total of needed number of people on a particular schedule is manually entered. What I want just as one example in O5 is if the sum of all category 1's entered totals in column M = 0, to just leave the cell blank. But if they do total a value, I want it to add up all the numbers of category 1 and divide that total by 100. I wasn't sure what type of formula to use in combination with a sumif formula to do this. Thank you for your time.
Bookmarks