Formula to add only certain columns in a range

JRosa

New Member
Joined
Sep 25, 2014
Messages
2
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>
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,311
Members
409,862
Latest member
lbisacca
Top