Thread: HELP ON THREED
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eddy Stan Eddy Stan is offline
external usenet poster
 
Posts: 151
Default HELP ON THREED

hi all,

My query is on track or out of track and can any one help me.



"Eddy Stan" wrote:

HI,
CAN YOU PL FIX THE ERROR - I GET REF! ERROR
=SUMPRODUCT(--(THREED('Jan ''08:May ''08'!$K$6:$K$8)=K12),THREED('Jan
''08:May ''08'!$L$6:$L$8))
this is only for testing before i use on required big range.
thanks in advance