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?