ProductIf

[Guest]

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...

 

[JE McGimpsey]

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))