Hi all,

I need to sum a column on a worksheet based on a reference returned from INDIRECT. I am having trouble with *error here*

My formula is:

=Sumif(indirect($a$4),indirect($b$4),*error here* indirect($a$4)&"!" & column())

$A$4 & $B$4 are worksheet names.

Essentially: If the worksheet name in A4=B4, then sum all values in worksheetname.column(). I want to use the column() function because I have to drag it across 100 columns. The column length is variable (1-10000).

Any ideas? The problem I run into is that column() returns a number, not a letter. I tried changing to R1C1, but I'm not familar with that technique.

Thanks-DSV