Forum Discussion
Formula using cells from another sheet
I know the most basic formulas which I why I need help with a more advanced one.
My spreadsheet has 2 tabs. One is a check register with a dollar amount in one column and a description of the transaction in the next column. The second tab is an Overhead sheet.
Since there are sometimes multiple rows on the Check Register tab with the same description but different amounts (fuel, meals, etc.), I want to be able to have excel add each cell with the same description over the month and enter the number in the Overhead tab.
I appreciate the help!
Beth
You don't need a formula. You need to employ the Pivot Table, which enables Excel to do the work for you. See the attached example as well as the resource there in the hyperlink
