K kilgore99 New Member Jul 6, 2012 #1 I have 12 columns, Jan-12 to Dec-12, in a date format. I would like to auto sum the column based on a =now() formula. My goal is to show a ytd number. The =now() is not necessary but I would like the auto feature when I open the worksheet. Thanks.
I have 12 columns, Jan-12 to Dec-12, in a date format. I would like to auto sum the column based on a =now() formula. My goal is to show a ytd number. The =now() is not necessary but I would like the auto feature when I open the worksheet. Thanks.
Montrey Member Jul 6, 2012 #2 Here ya go. =SUM(A2:OFFSET(A1,MONTH(TODAY())-1,0)) A2 would be january, A1 should always be above january
Here ya go. =SUM(A2:OFFSET(A1,MONTH(TODAY())-1,0)) A2 would be january, A1 should always be above january
X xld Member Jul 7, 2012 #3 Assuming that the dates are in A1:L1, I think you need =SUM(INDEX(A:L,0,MONTH(TODAY())))-INDEX(A1:L1,MONTH(TODAY())) adjust if your ranges are different.
Assuming that the dates are in A1:L1, I think you need =SUM(INDEX(A:L,0,MONTH(TODAY())))-INDEX(A1:L1,MONTH(TODAY())) adjust if your ranges are different.
