View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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!!