Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using THREED function with VLOOKUP to sum across multiple workshee | Excel Discussion (Misc queries) | |||
Multiple VLOOKUP or THREED for summary | Excel Discussion (Misc queries) |