I am getting an error to enter in a number between -999,999,999 and
999,999,999 with this formula

=SUMPRODUCT((I5='Other Sheet '!B2:B5000),(K5='Other Sheet
'!C2:C5000),(O5='Other Sheet '!E2:E5000),('Other Sheet
'!G2:G5000="2006"),('Other Sheet '!H2:H5000="1"),'Other Sheet '!I2:I5000)

Obviously something is wrong with the formula. I need the formula to check
account number, department, product number, year, and period. The year and
period is marked with the "2006" and the "1". The other is matching up one
sheet of data with another sheet of data. If all columns match, I need for
it to add the sum up of all those categories and put it in the period cell.
So, if I am in period 1 of 2006, I would want it to sum up all of the things
for that period that matches all 4 criteria.

I don't know how else to explain it. I really need help here.


"Brad_A" wrote:

yes and yes

I don't know why it isn't working and I am under heavy pressure to get it to
work. I really need help from someone.

"Ola" wrote:

Hi,

I presume "2006" and "1" is right and (Other is ('Other in the formula.

Ola