Posts by EExcelHelp

    Hi TBro, Thanks very much for your suggested answers. I have updated the data table with more rows and the end product layout on the right (shaded grey). Your suggestion would work if it only involves one group of expense category. Imagine I need to summarize the data into an income statement format every month. I am hoping there is a formula that can dynamically calculate the total based on the defined parameters. Any other thoughts or suggestions? Appreciate anyone's help.

    I need to calculate the YTD total based on a month input (cell A1 in the example). In addition, the summation is also based on several criteria. Attached is a sample of the data table. What is the formula to get the YTD Actuals of "OTHER" expenses? The YTD May total should be 191,420.


    Many Thanks.