Hello,

I am trying to sum up numbers from previous months, but I'd like to be able to choose specifically which months I want to sum. I already have a solution worked out in the attached file, but could someone please take a look and see if there is a more efficient way to do this?

I'm currently using checkboxes to select the months and then referencing those checkboxes when summing.
=SUM(IF(OR(D3),'Month 1'!B3,0),IF(OR(E3),'Month 2'!B3,0),IF(OR(F3),'Month 3'!B3))
With D3, E3, and F3 being the corresponding checkbox linked cells.

Thanks for your help,
Ben
Month Sum Test.xlsx