PDA

View Full Version : how run a sumif column name is true



lneilson
08-08-2008, 03:02 PM
Hi

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

thanks

lneilson

Bob Phillips
08-08-2008, 03:13 PM
=SUMIF(A:A,value,B:B)

perhaps?

lneilson
08-08-2008, 04:02 PM
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
08-08-2008, 04:59 PM
Sorry mate, yet again I have no idea what you are trying to achieve.