Subtotals only summing "random" columns when adding new row

I've tried about 10 different solutions on the boards to my problem. I'm basically splitting up some data, then bringing it back together and joining from another file, and just want to sum the columns to a new row for totals. I've tried looking at a number of reasons why this won't work, but I can't find the reason why some columns are summing then the others it's putting a null, then creating another column at the end of the worksheet with a value. I know this is pretty vague, but don't know how else to word this. Is there just a basic subtotal insert new row function I can put right after the union of whats 'unioned' together?

Developer

Developer Tools

Tips and Tricks

Common Use Cases

Best Practices

Accepted answers

fmvizcaino

Hi @dberroth ,

One possible reason to the null values could be due to null values between the fields you are using to realize the sum. If so, you could use a data cleansing tool before the subtotal tool to replace all null values by 0.

Let me know if that is your case.

Best,

Fernando Vizcaino

danilang

Hi @dberroth

Which macro are you using to add your total rows? The icon looks like the Crews Macro Add Totals but the configuration window doesn't match. Here's the config of the most recent one.

Dan

All comments

dberroth

Here is the view when I go in to the add totals option, everything is selected but once again, on the output, some columns come out null when there is clearly data, then decides to create new columns on the end such as " _1" with the values, I dunno?

fmvizcaino

Hi @dberroth ,

Let me know if that is your case.

Best,

Fernando Vizcaino

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703