Hi, I am wondering if there is a Multiply function that replaces the SUMIFS?
Basically the formula will look for 3 critertias and will return 4 different values. In a SUMIFS formula it will add the values however I need each of the 4 values to multiply.
Example 2, 3, 4, 5 in a SUMIFS will return 14. In the Multiply version I need this to return 120.
Thanks in advance
Basically the formula will look for 3 critertias and will return 4 different values. In a SUMIFS formula it will add the values however I need each of the 4 values to multiply.
Example 2, 3, 4, 5 in a SUMIFS will return 14. In the Multiply version I need this to return 120.
Thanks in advance