Thread: Error problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ayo Ayo is offline
external usenet poster
 
Posts: 489
Default Error problem

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?