count the number of populated cells in column N based on data in column D

Hi Good Evening,

This is probably quite an easy one but I'm new. I am working on a spreadsheet where data will be input daily to measure KPI's. I need cell I5 on KPI's sheet to divide the number of deales JD has on finance by the total number of deals he has done. I thought I needed to a calculation in another table, which I have tried in INPUT!N183

=SUMPRODUCT( (D6:D85="JD")*(N6:N85) ) This unfortunately gives #VALUE!

Then I was going to put

=INPUT!N183/'KPI''s'!D5

in KPI's!I5

I can see that once I have this formula, my document is complete. Can anyone please help?

Thanks in advance,

Caroline