3D SUMIF

[BimboUK]

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$339)})

 

[Jacob Skaria]

What about your previous post..Have you tried this?

=SUMPRODUCT(SUMIF(INDIRECT("'"&"sheet"&ROW(INDIRECT("1:25"))&"'!A:A"),
Reconciliation!$A10,INDIRECT("'"&"sheet"&ROW(INDIRECT("1:25"))&"'!D")))

If this post helps click Yes

 

[T. Valko]

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$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'!D3339)+SUMIF('Jul
out'!A3:A339,Reconciliation!A6,'Jul out'!D3339)