sumif formule using headers as criteria

[misscharliebrown]

Hi,
I have a spreadsheet (excel 2007) with columns headers that end in either
hrs, COR, or Inv. I would like to have a total columns also based on hrs ,
COR or Inv, I am tring to use the sumif formule but get stuck when I use the
RIGHT or the SEARCH function as a critera

eg =SUMIFS(datanalysis[[#This Row],[Pre-commission (hrs)]:[Post Contract
(Inv)]],datanalysis[[#Headers],[Pre-commission (hrs)]:[Post Contract
(Inv)]],"(RIGHT(D1:AG1,6)=RIGHT(AI1,6)"......

any suggestions?
R.

 

[Bob Phillips]

Try this array formula as an example

=SUM(IF(RIGHT(A1:H1,6)="abcxyz",A1:H100))

 

[T. Valko]

any suggestions?

Don't use structured references. Use standard A1 range referencing.