IT-Excel

From wiki.samerhijazi.net
Revision as of 16:01, 14 March 2023 by Samerhijazi (talk | contribs) (Init)
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"))