Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
SUMIF ? | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |