Error while using SUMPRODUCT function

R

Raj

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
 
D

Dave Peterson

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?
 
J

Jacob Skaria

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

=SUMPRODUCT((Sheet2!$D$2:$D$250="Latin America")*(Sheet2!$E$2:$E$250="App1"))
 
J

Jacob Skaria

This is not an array formula.. Check for any other validations for that cell
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using If with SumProduct help please! 2
Tracking using =sumproduct 3
Sumproduct using NOT equal to 7
IF-based SUMPRODUCT criteria 2
sumproduct failure? 4
Combine SUMPRODUCT with INDIRECT function 2
Problem with SUMPRODUCT 6
Sumproduct returns value error when ref is formula 2

Top