sumif formule using headers as criteria
 

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.

sumif formule using headers as criteria
 

any suggestions?

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

--
Biff
Microsoft Excel MVP


"misscharliebrown" wrote in
message ...
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.