ProductIf

B

ben townson

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

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