Aug 22 2023 10:33 AM
Why is an extra dollar amount being added to the merging spreadsheet? One tab is working correctly and the other tabs that are merge to the total spreadsheet is adding an extra dollar amount.
Aug 22 2023 10:40 AM
Could you please give bit more details - what are merging and subtotal spreadsheets, how do you add data to them, on which Excel platform/version you are.
Aug 22 2023 10:51 AM
Aug 22 2023 11:04 AM
How do you calculate totals in the main tab? That's SUM() or SUMIFS() on ranges in each tab, or these are links to cells with totals in individual tabs, our you use lookup functions, or something else. Do tabs have the same structure.
It's better if you could illustrate on the sample file or at least on screenshots.
Aug 23 2023 11:49 AM
Aug 24 2023 01:27 AM
Not sure what are the names of your sheets, with formula
=SUM( 'TOTALS:SHOES'!I18 )
you sum values in cell I18 in all sheets between TOTALS and SHOES, i.e. that's the equivalent of something like
=TOTALS!I18 + BALLS!I18 + SHOES!I18
Perhaps you'd like to have total only in SHOES, when it's simply
=SHOES!I18