IT-Excel

From wiki.samerhijazi.net
Revision as of 14:02, 14 March 2023 by Samerhijazi (talk | contribs) (Created page with "=Init= =SUMPRODUCT(SUBTOTAL(3;OFFSET(B3:B399;ROW(B3:B399)-MIN(ROW(B3:B399));;1;));N(B3:B399="FF"))")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Init

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