Hi, I am looking for a formula, that takes a cell value and uses it as a column in a SUMIF formula in another cell.
E.g. A1=B - where letter B will be used as column B in the SUMIF formula. B is also calculated by a formula in A1, but the cell shows B in the end (or C, D, E etc.)
A2=SUMIF($x:$x,A23,C:C) - where in $x x would come from cell A1's value, so in this case it would be =SUMIF($B:$B,A23,C:C) .
Is there such formula available?
Thank you, Zsuzsa
E.g. A1=B - where letter B will be used as column B in the SUMIF formula. B is also calculated by a formula in A1, but the cell shows B in the end (or C, D, E etc.)
A2=SUMIF($x:$x,A23,C:C) - where in $x x would come from cell A1's value, so in this case it would be =SUMIF($B:$B,A23,C:C) .
Is there such formula available?
Thank you, Zsuzsa