You don't need an array formula

=IF(COUNT(C10:C137)=0,NA(),SUMPRODUCT(--($A$10:$A$137=$A141),--(ISNUMBER(C$10:C$137)),C$10:C$137))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Barb Reinhardt" wrote in message
...
I have this sumproduct equation

=SUMPRODUCT(--($A$10:$A$137=$A141),(IF(ISNUMBER(C$10:C$137),C$10 :C$137)))

And I'm getting ZEROS for a result if there is a blank value in the cells
C$10:C$137 that match the first condition. What do I need to change to
get
it to display an NA if all of the matching cells are blank?

Thanks