I have this formular:
=SUMPRODUCT(--(Tables!$C$2:$C$2979=$A4),--(Tables!$D$2:$D$2979=$B4),--(Tables!$E$2:$E$2979="Yes"))

but it is showing as an error. Iknow there is no errors in there but when I
click the Trace Error option I get a little "Table" icon and I don't know
what that is or what it means.
Any ideas?

Hi,

There's nothing wrong with the formula so it must be the data, what 'error'
are you getting?

Mike

"Ayo" wrote:

I have this formular:
=SUMPRODUCT(--(Tables!$C$2:$C$2979=$A4),--(Tables!$D$2:$D$2979=$B4),--(Tables!$E$2:$E$2979="Yes"))

but it is showing as an error. Iknow there is no errors in there but when I
click the Trace Error option I get a little "Table" icon and I don't know
what that is or what it means.
Any ideas?

I get the #N/A

Hi,
the missing part in the formula is where you want to pull the information if
the three conditions are met, let's say column F

=SUMPRODUCT(--(Tables!$C$2:$C$2979=$A4),--(Tables!$D$2:$D$2979=$B4),--(Tables!$E$2:$E$2979="Yes"),Tables!$F$2:$F$2979)

"Ayo" wrote:

I have this formular:
=SUMPRODUCT(--(Tables!$C$2:$C$2979=$A4),--(Tables!$D$2:$D$2979=$B4),--(Tables!$E$2:$E$2979="Yes"))

but it is showing as an error. Iknow there is no errors in there but when I
click the Trace Error option I get a little "Table" icon and I don't know
what that is or what it means.
Any ideas?

Look for error(s) in one (or all) of those ranges.

Remember to look in hidden rows, too.

Ayo wrote:

I have this formular:
=SUMPRODUCT(--(Tables!$C$2:$C$2979=$A4),--(Tables!$D$2:$D$2979=$B4),--(Tables!$E$2:$E$2979="Yes"))

but it is showing as an error. Iknow there is no errors in there but when I
click the Trace Error option I get a little "Table" icon and I don't know
what that is or what it means.
Any ideas?

--

Dave Peterson

No hidden rows and no links to other tables, which was my first suspision

"Dave Peterson" wrote:

Look for error(s) in one (or all) of those ranges.

Remember to look in hidden rows, too.

Ayo wrote:

I have this formular:
=SUMPRODUCT(--(Tables!$C$2:$C$2979=$A4),--(Tables!$D$2:$D$2979=$B4),--(Tables!$E$2:$E$2979="Yes"))

but it is showing as an error. Iknow there is no errors in there but when I
click the Trace Error option I get a little "Table" icon and I don't know
what that is or what it means.
Any ideas?

--

Dave Peterson

Did you look for errors in any of those ranges?

Ayo wrote:

No hidden rows and no links to other tables, which was my first suspision

"Dave Peterson" wrote:

Look for error(s) in one (or all) of those ranges.

Remember to look in hidden rows, too.

Ayo wrote:

I have this formular:
=SUMPRODUCT(--(Tables!$C$2:$C$2979=$A4),--(Tables!$D$2:$D$2979=$B4),--(Tables!$E$2:$E$2979="Yes"))

but it is showing as an error. Iknow there is no errors in there but when I
click the Trace Error option I get a little "Table" icon and I don't know
what that is or what it means.
Any ideas?

--

Dave Peterson


--

Dave Peterson

I have been going over and over all of the data and I can't find anything. I
tried the help function in excel and I learned that when I see "a black arrow
points from the selected cell to a worksheet icon" that the cell "is
referenced by a cell on another worksheet or workbook". I checked and there
are no references. I deleted all the references in the Name Manager also.

"Dave Peterson" wrote:

Did you look for errors in any of those ranges?

Ayo wrote:

No hidden rows and no links to other tables, which was my first suspision

"Dave Peterson" wrote:

Look for error(s) in one (or all) of those ranges.

Remember to look in hidden rows, too.

Ayo wrote:

I have this formular:
=SUMPRODUCT(--(Tables!$C$2:$C$2979=$A4),--(Tables!$D$2:$D$2979=$B4),--(Tables!$E$2:$E$2979="Yes"))

but it is showing as an error. Iknow there is no errors in there but when I
click the Trace Error option I get a little "Table" icon and I don't know
what that is or what it means.
Any ideas?

--

Dave Peterson


--

Dave Peterson

Are you sure that the formula you posted is what was used in the cell?

Your formula doesn't really look like:
=table(x1,y1)
does it?

Ayo wrote:

I have been going over and over all of the data and I can't find anything. I
tried the help function in excel and I learned that when I see "a black arrow
points from the selected cell to a worksheet icon" that the cell "is
referenced by a cell on another worksheet or workbook". I checked and there
are no references. I deleted all the references in the Name Manager also.

"Dave Peterson" wrote:

Did you look for errors in any of those ranges?

Ayo wrote:

No hidden rows and no links to other tables, which was my first suspision

"Dave Peterson" wrote:

Look for error(s) in one (or all) of those ranges.

Remember to look in hidden rows, too.

Ayo wrote:

I have this formular:
=SUMPRODUCT(--(Tables!$C$2:$C$2979=$A4),--(Tables!$D$2:$D$2979=$B4),--(Tables!$E$2:$E$2979="Yes"))

but it is showing as an error. Iknow there is no errors in there but when I
click the Trace Error option I get a little "Table" icon and I don't know
what that is or what it means.
Any ideas?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson