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

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

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