Dear excel brothers and sisters, need your help please on something that perhaps is simple problem 
1) I have a cash flow that runs on periods:
ROW 1 - PERIODS: 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 /
ROW 2 - CASH FL: 1 / 1 / 1 / 1 / 1/ 1 / 1 / 1 / 1/
ROW 3 - CELL: A3=5
2) My goal is to sum the cash-flow starting from a certain period (criteria). For example:
SUMIF( PERIODS , ">5", CASH FL ) = returns summation of 4.
3) NOW I am hard-coding the criteria in the formula as a number. It works, but it is not dynamic.
3.1) HOWEVER the period (criteria) changes and needs to be tied into another cell (in our example A3), so it will be changed from period 1 to 9. For example:
SUMIF( PERIODS , ">A3", CASH FL ) = returns summation of 4
Unfortunately this last syntax does not work for me. What am I doing wrong? Alternatives?
1) I have a cash flow that runs on periods:
ROW 1 - PERIODS: 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 /
ROW 2 - CASH FL: 1 / 1 / 1 / 1 / 1/ 1 / 1 / 1 / 1/
ROW 3 - CELL: A3=5
2) My goal is to sum the cash-flow starting from a certain period (criteria). For example:
SUMIF( PERIODS , ">5", CASH FL ) = returns summation of 4.
3) NOW I am hard-coding the criteria in the formula as a number. It works, but it is not dynamic.
3.1) HOWEVER the period (criteria) changes and needs to be tied into another cell (in our example A3), so it will be changed from period 1 to 9. For example:
SUMIF( PERIODS , ">A3", CASH FL ) = returns summation of 4
Unfortunately this last syntax does not work for me. What am I doing wrong? Alternatives?
