Hi, I am trying to supply column values to the sumif function, but have not
had any success yet. Here's what the macro coded-

Range("B34").Select
ActiveCell.FormulaR1C1 = _
"=SUMIF('LCY Balances'!C6,'By Type'!RC1,'LCY Balances'!C7)"

if simply used in excel this would read as -

=SUMIF('LCY Balances'!$F:$F,'By Type'!$A34,'LCY Balances'!$G:$G)

What I am trying to do is - to make the sumif function sum up values in
sheet "By Type" in the column referred to by a number in row32 of the active
cell/column - in this case 7 (columnG:G)

I've tried to be as detailed as possible but do let me know if you need
further details. Will be glad if somebody offers a solutions soon!

Thanks