Difference between revisions of "IT-Excel"
Jump to navigation
Jump to search
Samerhijazi (talk | contribs) (→Init) |
Samerhijazi (talk | contribs) |
||
| Line 1: | Line 1: | ||
=Init= | =Init= | ||
| + | <pre class="code"> | ||
=COUNTIF(B3:B300;"FF") | =COUNTIF(B3:B300;"FF") | ||
=SUMPRODUCT(SUBTOTAL(3;OFFSET(B3:B399;ROW(B3:B399)-MIN(ROW(B3:B399));;1;));N(B3:B399="FF")) | =SUMPRODUCT(SUBTOTAL(3;OFFSET(B3:B399;ROW(B3:B399)-MIN(ROW(B3:B399));;1;));N(B3:B399="FF")) | ||
| + | </pre> | ||
Latest revision as of 16:01, 14 March 2023
Init
=COUNTIF(B3:B300;"FF") =SUMPRODUCT(SUBTOTAL(3;OFFSET(B3:B399;ROW(B3:B399)-MIN(ROW(B3:B399));;1;));N(B3:B399="FF"))
