Quote:
|
Originally Posted by MartinW
For the second part of your question you could use a helper
column (say column G) with the numbers 1 to 20 or whatever
descending down the column.
Your formula will then be
=SUMPRODUCT(--('All History'!$B$2:$B$2000=$G1)
As you copy down the $G1 reference will update to $G2, $G3 etc.
HTH
Martin
|
Thank you for the help, but I now have a new problem: the helper column seems to stop "helping" after the first dozen numbers or so, Why is this?
The first couple of lines work on the first few sheets in the workbook, but then it seems to stop - all of my formulas only produce zeros. It shouldn't produce zeros especially when there is data that I know for a fact should be there. What am I doing wrong? I have a workbook with aprox. 50 pages and they all reference the first in their formulas. If you need more info, please let me know. Since there is SO much data and it is sensitive, I don't want to try to post it here. I look forward to your help.