#N/A error
 

I have a workbook that is formated with formulas pulling data from a data
sheet within the same workbook. When I add new data into the data sheet I am
getting this error. I dont understand why. I am using Sumproduct formulas the
data is formated the same way and within the ranges. Please help.

#N/A error
 

Post the formula that is giving you the error.
--
Brevity is the soul of wit.


"Scott@CW" wrote:

I have a workbook that is formated with formulas pulling data from a data
sheet within the same workbook. When I add new data into the data sheet I am
getting this error. I dont understand why. I am using Sumproduct formulas the
data is formated the same way and within the ranges. Please help.

#N/A error
 

=SUMPRODUCT((DATA!$A$2:$A$17771="DEC06")*(DATA!$D$ 2:$D$17771="Frontline")*(DATA!$M$2:$M$17771={"2110 220210","2110220810","2110220220","2110220310","21 10220320","2110220410","2110220420","2110220421"," 2110220821","2110220422","2110220510","2110220520" ,"2110220110","2110220120","2210220121","211022061 0","2110220612","2110220710","2110220620","2110220 621","2110220720"}))

I found the problem. For some reason one cell in column D had #N/A, once I
fixed that on the data sheet everything fell in line. Not sure why, it did
not just skip that and move on to the next cell though.

"Dave F" wrote:

Post the formula that is giving you the error.
--
Brevity is the soul of wit.


"Scott@CW" wrote:

I have a workbook that is formated with formulas pulling data from a data
sheet within the same workbook. When I add new data into the data sheet I am
getting this error. I dont understand why. I am using Sumproduct formulas the
data is formated the same way and within the ranges. Please help.