Sumproduct produces #N/A

Originally Posted by mcmahobt

If you're worried about dynamic ranges and not wanting to have to worry about changing the ranges manually, you could always make your data table an Excel Table by highlighting the data range, press CTRL+T, and insert your formula there. Your SUMPRODUCT formula will then autoadjust to take into account the new data entered.

That said, what is the result of the data in column I? Is it text or numerical data? You may want to upload a sample workbook too.

Thanks for your reply, Column M and P are the SUMPRODUCT columns I want to extend to 25000 rows.

Sample - SUMPRODUCT Issue.xlsx