Thread: Formula results in error - don't know why
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeremy Jeremy is offline
external usenet poster
  
Posts: 85
Default Formula results in error - don't know why
I get a value error with the below,
Any ideas why?

=SUMPRODUCT((Data!K7:K9999='Monthly Summary'!A10)*(Data!AE7:AE9999=Data!C1))

Reply With QuoteReply With Quote