I have a budget that runs 12 months across. Each month has a column for Actual, Budget and Variance. A3 contains the date of the budget. I'm using the formula below to show total to date as of that date. This adds up everything. What i can't figure out is how to only add the columns that are Actual or Budget or Variance. =SUM(C6:INDEX(C6:BH6,MATCH(A3,C3:BH3,0))) |
<tbody>
</tbody>