how run a sumif column name is true

[lneilson]

Hi

how can I run a Sumif based on the column name with an unknown range

thanks

lneilson

[Bob Phillips]

=SUMIF(A:A,value,B:B)

perhaps?

[lneilson]

thanks for the reply this is killing me

I need to add the cells in each row that are in the columns labled sun in (lable is in row 82 )
please see attached file I need the sumif to replace :

"=sum(A" & intCounter":" & Columns(intColLast).Cells(intCounter, 1).Address & ")"

I don't know how to set the range or pretty much anything
any help will be apprechiated

lneilson

[Bob Phillips]

Sorry mate, yet again I have no idea what you are trying to achieve.