3D Sumif - help using!
 

Hi everyone. Does anyone know how to use the 3D Sumif UDF that is at the
following website?
http://www.dailydoseofexcel.com/arch...ned-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!!

3D Sumif - help using!
 

Steph,

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

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

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

HTH,
Bernie
MS Excel MVP


"Steph" wrote in message ...
Hi everyone. Does anyone know how to use the 3D Sumif UDF that is at the
following website?
http://www.dailydoseofexcel.com/arch...ned-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!!