1

So i have a column with numbers and want to sum the column, but i want them to be rounded up to the nearest thousand.

=SUM(ARRAYFORMULA(ROUNDUP(J4:J ,-3)))

I tried this however I am just getting a Formula parsing error.

The goal is for this:

100
900
5600

To give me 8000.

2

1 Answer 1

0

A parse error indicates a syntax issue in a formula. The formula you quote should work fine in the United States locale.

In the event your locale uses commas as decimal separators, replace the comma , in the formula with a semicolon ;.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.