ProductIf
 

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 ,
"ben townson" 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...