IT-Excel

From wiki.samerhijazi.net

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"