Cell range and Sheet Summary

I have an expense 'tracker'. Essentially it tracks if employees submitted their expenses

(1) correct the first time;

(2) expense was sent back for revision;

(3) submitted late

(4) did not submit

My columns across top are months of the year. My rows are employee names.

I have a sheet summary that totals (1), (2), (3) and (4). I would LOVE to have a field in the Summary that specifies the range (as each month the range changes) and then set up each of the 4 summary fields to reference the field where the range is. This way I only have to come in once a month and update the Summary field containing the range. However, I've not been able to figure this out.

Perhaps this isn't possible?

Thank you.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!