IT-Excel

From wiki.samerhijazi.net

Revision as of 16:01, 14 March 2023 by Samerhijazi (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

Init

=COUNTIF(B3:B300;"FF")
=SUMPRODUCT(SUBTOTAL(3;OFFSET(B3:B399;ROW(B3:B399)-MIN(ROW(B3:B399));;1;));N(B3:B399="FF"))

Retrieved from "http://wiki.samerhijazi.net/index.php?title=IT-Excel&oldid=2863"