I am trying to use a SUMIF function in an Excel worksheet to total a number of amounts in a row where the corresponding column name for each amount ends in the text string "Cost".
So, in my example here,
I want to total any amount in range H4:DG4 that has a column heading (H2:DG2) which ends in the text "Cost".
I can't get it to work !
Any ideas ? Thanks for your help.