Error problem
This is exactly what is in the cell:
=SUMPRODUCT(--(Tables!$C$2:$C$2958=$A4),--(Tables!$D$2:$D$2958=$B4),--(Tables!$E$2:$E$2958="Yes"))
"Dave Peterson" wrote:
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
|