ProductIf-that works in a similar fashion

Has anyone written a ProductIf function that works in a similar fashion to a
standard SumIf or Countif function? I hate to even consider writing a
combination of Product() and IF()'s to handle a huge pile of data...

One way:

Depends on the function. Say you want to multiply all the values in rng2
if rng1 meets a criterion, say, >=3. Array-enter (CTRL-SHIFT-ENTER or
CMD-RETURN):


=PRODUCT(IF(rng1>=3, rng2))



In article <F8028840-DA6D-4093-AF51-2FEF84472CF7@microsoft.com>,
"ben townson" <bentownson@discussions.microsoft.com> wrote:

> Has anyone written a ProductIf function that works in a similar fashion to a
> standard SumIf or Countif function? I hate to even consider writing a
> combination of Product() and IF()'s to handle a huge pile of data...