I get a Value# sign when I enter the formulaEnter it as an array formula
The formula should work so that for any number of rows chosen, column C will be adjustedChange all 200's to a cell address and enter 200 or whatever in that cell.
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.