SUMIF

[Uddinj1]

Hi All,

I need help with the following formula.

SUMIF('Sheets2'!A:A,A9,'Sheets2'!L:L)

This formula is in sheets 1

My problem is that the column address in the first part of the formula
'Sheets2'!A:A changes depending on a condition in A9 in sheets 1. It can be
A:A, B:B, C:C,D but not others.

First of all is this possible to write a formula that will take account of the
changes in A9? I have tried to replace the first part with Match function but
not getting anywhere. Thanks in advance for your help.

Regards

UJ

 

[Don Guillett]

Have a look at INDIRECT in help

 

[Frank Kabel]

Hi
if cell A1 contains the column charcacter try
=SUMIF(INDIRECT("'Sheets2'!" & A1 & ":" & A1),A9,'Sheets2'!L:L)