CODEWITHSUNDEEP
excel-formula
user3263215
user3263215

Reputation: 63

Percentage Increase between the sum of two seperate sets of cells

I am looking at calculating percentage change in excel between the sum of two numbers. Say for example, "=SUM(E141:M141)/SUM(Q141:Y141)-1". This works fine. However, if any of the sums above turn out to be zero, excel goes mental. I can adjust the formula to work with single cells but not with sums of two separate cells. Is there a workaround for this?

Upvotes: 0

Views: 1252

Answers (1)

Reilly Cooper-Jackson
Reilly Cooper-Jackson

Reputation: 46

The way I am interpreting your question based on the formula you provided is:

B is % of A different to A

For example two sums A = 20; B = 30 results in (30/20)-1=0.5. Essentially B is 50% different to A with respect to A.

As Robin Gertenbach mentioned you can use IFERROR() to modify your formula into,

=IFERROR(SUM(E141:M141)/SUM(Q141:Y141)-1, 0)

edit: your last statement asks if you can still calculate a percentage even when one of the values is 0. The answer is no. The difference between a number and 0 is infinite, no other solution exists.

Upvotes: 3

Related Questions