Tracking salary overall versus by month per person

I have a budget sheet that tracks the overall salary spent on each staff. I have a column formula that can search by name to give me the total amount spent on that staff to date ( =SUMIF([Areas of Project Spending]:[Areas of Project Spending], PERSONNEL@row, Spent:Spent)).

What I need now is a new column that will total salary for the month only by staff name - how do I add that to this formula (or think it needs to be a SUMIF) to get it to total by the current month only? FYI - I do have a date column (Expense Date) for when the salary posts each month.

Thank you wonderful people of SS!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!