Hi,

I was wondering if someone can help me with a SUMIFS formula. The following is what I currently have:

=SUMIFS(**'Preventive Maintinance Report '!$AX:$AX**,'Preventive Maintinance Report '!$A:$A,"P2",'Preventive Maintinance Report '!$D:$D,'Maintenance Hrs Rprt Drill Down'!$A11)

Instead of defining the sum range as **'Preventive Maintinance Report '!$AX:$AX**, I would like to do a lookup based on column heading. For example, if row 3 containing headers has machine C1, C2, Total, assume Column AX is total. I want to specify in a cell above my report to pull "C1" data and have the formula update to change the range.

I looked at a few examples online with SUMIF formula but it didn't help. I would really appreciate it if someone could help me out. Thanks.