Forum Discussion
kcbikeswim
Jul 15, 2021Copper Contributor
need excel formula
I need help with writing a formula. What I need is an auto sum formula that will total a line of cells with numbers that are both positive and negative numbers, but not adding and subtracting, only t...
- Jul 15, 2021
=SUM(ABS(A1:A4))
Detlef_Lewin
Jul 15, 2021Silver Contributor
=SUM(ABS(A1:A4))
kcbikeswim
Jul 15, 2021Copper Contributor
Thank you so much. Really appreciate the help