Home > Enterprise >  ARRAYFORMULA with COUNT
ARRAYFORMULA with COUNT

Time:08-24

im trying to come up with an ARRAYFORMULA to substitute formulas on every row

=IF(ISBLANK(A2);""; COUNTA(FILTER((Derivatives!B:B);INDEX((Derivatives!D:D);0;0)= left(A2;4);INDEX((Derivatives!F:F);0;0)= "EQUITY CALL")))

enter image description here

  • Related