Forum Discussion

Still-Learning's avatar
Still-Learning
Copper Contributor
Mar 10, 2023

Remove duplication in Excel YTD Budget Summary Template

Hi, I am using the Excel YTD Budget Summary template and I am getting a doubling in the Actual column of the Monthly Expense Summary Totals. =SUMIF(MonthlyExpensesSummary[G/L Code],[@[G/L Code]],Mo...
excel
Formulas and Functions
Still-Learning's avatar
Still-Learning
Copper Contributor
Mar 10, 2023
I figured out the problem. There were rows with sample data that were hidden and had the same account numbers and data entered.

Resources