View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Sumproduct question

I have the following Sumproduct formula and I'm getting a #Value error

=SUMPRODUCT(--(ISNUMBER(32:32)),--(YEAR(32:32)=U16))

I know that A32 is not a number, so the YEAR(32:32) part returns #VALUE for
the first entry. How do I get around this?

Thanks.