Difference between revisions of "IT-Excel"
Jump to navigation
Jump to search
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"))") |
Samerhijazi (talk | contribs) (→Init) |
||
| Line 1: | Line 1: | ||
=Init= | =Init= | ||
| + | =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")) | ||
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"))
