Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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... |
#2
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|