Need assistance writing a formula for one column with two purposes
I am creating a budget sheet and I would like to have a formula that calculates BOTH:
1) SUM across several cells in a row when box is not checked AND
2) SUM down a column if box is checked.
So far, I have been able to write a formula that calculates the SUM across several cells (and have added in a bit to return a blank cell when the box is checked).
Here is an example formula so far (for "Summer: Expenses):
=IF([Pay Period]@row = 0, (SUM([Summer 1]@row:[Summer 4]@row)))
Can you assist me is altering this formula to calculate both across a row and then down a column? I have attached a sample table.
Thanks for your help!
Help Article Resources
Check out the Formula Handbook template!