Hello!
I'm writing a complex formula that starts with AVERAGEIFS. It counts average in specified row number for a number of conditions, but that row number is dynamic. How to make it work?
Simple example:
gives sum of everything in row 5.
shows me the position of "111008" product number in column A, which is 5.
is wrong. I tried to add some "" here and there, but can't make it work equivalent to =SUM(5:5) formula.
Finally, I'd like to replace 111008 with cell reference too, but the principle of referencing whole row number is what I can't get right.
I'm writing a complex formula that starts with AVERAGEIFS. It counts average in specified row number for a number of conditions, but that row number is dynamic. How to make it work?
Simple example:
Excel Formula:
=SUM(5:5)
Excel Formula:
=MATCH(111008;A:A;0)
Excel Formula:
=SUM(MATCH(111008;A:A;0):MATCH(111008;A:A;0))
Finally, I'd like to replace 111008 with cell reference too, but the principle of referencing whole row number is what I can't get right.