I'm hoping this has an easy answer, but I honestly don't even know how to ask the question in a concise enough way to search for it - so I apologize if this has already been resolved/answered elsewhere.
I have a budget worksheet with tabs for each month and a summary tab. On the summary tab, I have a list of expenses. Within each month tab, there is a dropdown to select the expense and a column for the dollar amount, and then the summary tab populates the sum of each expense from the month tabs. I found an error in my cell populations though and now need to repopulate the summary tab with a variation to the first formula below, but updating ONLY the “B” number when I drag the corner of the cell down the column. Instead, when I drag to populate, it wants to sequentially update all of the numbers so the formulas end up looking like this:
=SUMIF(May!C12:C51,B13,May!D12:D51)
=SUMIF(May!C13:C52,B14,May!D13:D52)
=SUMIF(May!C14:C53,B15,May!D14:D53)
Again, I would like it to only sequentially update the B number so it should look like this instead:
=SUMIF(March!C12:C51,B13,March!D12:D51)
=SUMIF(March!C12:C51,B14,March!D12:D51)
=SUMIF(March!C12:C51,B15,March!D12:D51)
Is there a way to update each column in my summary tab so it only updates the B number when I drag it down the column, rather than having to manually update each cell?
I have a budget worksheet with tabs for each month and a summary tab. On the summary tab, I have a list of expenses. Within each month tab, there is a dropdown to select the expense and a column for the dollar amount, and then the summary tab populates the sum of each expense from the month tabs. I found an error in my cell populations though and now need to repopulate the summary tab with a variation to the first formula below, but updating ONLY the “B” number when I drag the corner of the cell down the column. Instead, when I drag to populate, it wants to sequentially update all of the numbers so the formulas end up looking like this:
=SUMIF(May!C12:C51,B13,May!D12:D51)
=SUMIF(May!C13:C52,B14,May!D13:D52)
=SUMIF(May!C14:C53,B15,May!D14:D53)
Again, I would like it to only sequentially update the B number so it should look like this instead:
=SUMIF(March!C12:C51,B13,March!D12:D51)
=SUMIF(March!C12:C51,B14,March!D12:D51)
=SUMIF(March!C12:C51,B15,March!D12:D51)
Is there a way to update each column in my summary tab so it only updates the B number when I drag it down the column, rather than having to manually update each cell?
