I have a spreadsheet I am trying to build as template for a budget. In one tab I have listed all our customers and the budgeted amount of income per month. Included in that tab is a column showing the type of income for each client (which income account) by month, it could be one of 6 different types. I have another tab which shows the budget totals by account (a summary for each of the 6). How can I create a formula that will sum for each monthly column all those with income account A and post that in the budget tab with totals, ditto for B, etc. I tried the Sumif but that apparently only looks at the column with the values. I need to be able to sum that value column if the value in a separate column (the account name) matches.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.