Can sumif take range value as a cell reference

[Ibarot]

Hello,
I am trying to create a table in which I have multiple sumif functions across multiple sheets.

I am trying to create a SumIf function which takes its first argument as a cell reference. Is this Possible?

e.g. instead of Sumif(C2:C10,100,B2:B100), I entered the range C2:C100 in cell A1.

Now when I try sumif(A1,100, B2:B100) it does not work. Is there any way I can use sumif range value as a cell reference?

[Lupp]

You may consider to read (and probably regard) Why do I often get an error (508, 504, 502 e.g.) if I paste a Calc formula from some post into my sheet? .

[Zizi64]

Use the function INDIRECT() to reference the desired cell range based on the string located in A1.

[Ibarot]

Thank you so much. This perfectly solved my problem.