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

Error while using SUMPRODUCT function
 

This formula doesn't need to be array entered (ctrl-shift-enter). Just enter it
normally.

Does this cell have any Data|Validation applied to it?


Raj wrote:

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

--

Dave Peterson

Error while using SUMPRODUCT function
 

Check the sheet name...Is that just 'Sheet'

=SUMPRODUCT((Sheet2!$D$2:$D$250="Latin America")*(Sheet2!$E$2:$E$250="App1"))
--
If this post helps click Yes
---------------
Jacob Skaria


"Raj" wrote:

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

Error while using SUMPRODUCT function
 

This is not an array formula.. Check for any other validations for that cell
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Check the sheet name...Is that just 'Sheet'

=SUMPRODUCT((Sheet2!$D$2:$D$250="Latin America")*(Sheet2!$E$2:$E$250="App1"))
--
If this post helps click Yes
---------------
Jacob Skaria


"Raj" wrote:

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