Thread: Formula results in error - don't know why
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default Formula results in error - don't know why
The syntax of the formula is fine but depending on your data this might work
better...

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

--
HTH...

Jim Thomlinson


"Jeremy" wrote:

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