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
|