I ran the subtotal function, and it spat out all of the subtotals based on my criteria that was specified into the cell directly underneath the set criteria that I told it to...basically like it is supposed to do. Any way, I would like to keep the subtotal fields for the data that is being added up, but would like to move it to the column directly to the right. I ran an if function and got what I wanted, the problem is that I need to hide all of the cells that the if function is pulling from, which will hinder my ability to effectively add data in rows that need data added to them. It is quite a large spreadsheet so I would prefer no to cut and paste each item to the cell I want it in. Is there a way to move each subtotal one to the right and then one up so I can delete unnecessary rows? My subtotals are in column I4 and I would like them to be in J4, etc... I hope that makes sense, thanks in advance for any advice.
Bookmarks