=SUMPRODUCT((B1773:B1795=L1772)*(C1773:C1795))Please Login or Register to view this content.
The above formula works fine as long as the first row in the range is the same as the first row with data. If I replace row 1773 references with row 1772, then the formula fails (#VALUE). I've tried this on another spreadsheet with some made up data, and I could not duplicate the problem.
Bookmarks