Simplify a sum.if - and divide formula

Originally Posted by blak9

Is there a way to simplify my formula..?
it gets the job done

If it ain't broke, don't try to fix it!
To try and simplify it (if at all possible), you would need to replace the repeated part that you want to remove with a series of less efficient arrays capable of performing the same task.