Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D SUMIF
I can't get thisd more func function to work - can anyone see what is wrong
=SUMIF({=THREED(Aug Out:Jul Out!A$3:A$339)},Reconciliation!A6,{=THREED(Aug Out:Jul Out!D$3:D$339)}) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D SUMIF
What about your previous post..Have you tried this?
=SUMPRODUCT(SUMIF(INDIRECT("'"&"sheet"&ROW(INDIREC T("1:25"))&"'!A:A"), Reconciliation!$A10,INDIRECT("'"&"sheet"&ROW(INDIR ECT("1:25"))&"'!D:D"))) If this post helps click Yes --------------- Jacob Skaria "BimboUK" wrote: I can't get thisd more func function to work - can anyone see what is wrong =SUMIF({=THREED(Aug Out:Jul Out!A$3:A$339)},Reconciliation!A6,{=THREED(Aug Out:Jul Out!D$3:D$339)}) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D SUMIF
THREED has problems with sheet names that contain spaces. Rename the sheets
removing the spaces and it will work. =SUMPRODUCT(--(THREED(AugOut:JulOut!A$3:A$339)=Reconciliation!A6 ),THREED(AugOut:JulOut!D$3:D$339)) However, if you only have 2 sheets to calculate you're better off using a simple SUMIF (and you won't have to rename the sheets!): =SUMIF('Aug out'!A3:A339,Reconciliation!A6,'Aug out'!D3:D339)+SUMIF('Jul out'!A3:A339,Reconciliation!A6,'Jul out'!D3:D339) -- Biff Microsoft Excel MVP "BimboUK" wrote in message ... I can't get thisd more func function to work - can anyone see what is wrong =SUMIF({=THREED(Aug Out:Jul Out!A$3:A$339)},Reconciliation!A6,{=THREED(Aug Out:Jul Out!D$3:D$339)}) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Help on SUMIF | New Users to Excel | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |