Connie Martin wrote:
Sorry. This gives me #VALUE!. Connie

"Infinitogool" wrote:

Hi Connie
Try in E10
=SUMPRODUCT((A39:A1000=A10)*J39:J1000)

Regards,
Pedro J.

That looks like an array formula. Try entering the formula by pressing
Ctrl + Shift + Enter.