3D Sumif - help using!

[Steph]

Hi everyone. Does anyone know how to use the 3D Sumif UDF that is at the
following website?
http://www.dailydoseofexcel.com/archives/2006/02/25/3d-user-defined-functions/

An example of the 3 required arguments would be extremely helpful (ie, which
arguments are 3D, which are not, which are strings, etc.)

Thank you!!

 

[Bernie Deitrick]

Steph,

In the second set of function definitions, the functiom SumIf3D2 is used like

=SumIf3D2("Sheet1:Sheet2!A2:A11",">4","Sheet1:Sheet2!B2:B11")

All are strings, though 2 can be 3-D references.

HTH,
Bernie
MS Excel MVP