Need help creating a formula

[Lori B.]

Hi! I need to create a formula that will first add all of column E, add all of column K, then subtract the sum of column K from the sum of column E, then divide this # by the sum of column E. I've tried a variety of combinations but I can't seem to get it right. Any help would be appreciated. Thanks!

 

[JE McGimpsey]

What you're asking for is

=(SUM(E:E)-SUM(K:K))/SUM(E:E)

which can be a bit more efficiently written:

=1-SUM(K:K)/SUM(E:E)

 

[Lori B.]

Thanks! Worked great!