Forum Discussion
Solved
How do I find the sum of cells that are either one number or the other?
I have a spreadsheet with 2500 rows of 10 randomly generated numbers (either 1, -1, 10, -10, 100 or -100). For every row, I want 3 functions. The first would calculate the absolute value of the sum o...
You can change the formulas as follows:
=SUMPRODUCT(IF(ABS(A1:J1)=1,A1:J1))
=SUMPRODUCT(IF(ABS(A1:J1)=10,A1:J1))/10
=SUMPRODUCT(IF(ABS(A1:J1)=100,A1:J1))/100
Haytham Amairah Twifoo Thank you, but this wasn't what I was looking for.
I meant that I want something like this:
-1 1 -1 1 1 would return the answer of 1 because -1 + 1 + (-1) + 1 + 1 = 1.
You can change the formulas as follows:
=SUMPRODUCT(IF(ABS(A1:J1)=1,A1:J1))
=SUMPRODUCT(IF(ABS(A1:J1)=10,A1:J1))/10
=SUMPRODUCT(IF(ABS(A1:J1)=100,A1:J1))/100
Thank you Haytham Amairah !