View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Raj Raj is offline
external usenet poster
 
Posts: 130
Default Error while using SUMPRODUCT function

HI All

I have to enter the formula as follows
=SUMPRODUCT((Sheet!$D$2:$D$250="Latin America")*(Sheet!$E$2:$E$250="App1"))

This is a array formula once i execute this formula i am getting a error as
follows

"Please enter a Valid Integer or Decimal Number"

Can you please let me know what is the reson for this and how to overcome this

Raj