Bawo ni o ṣe ṣe Countif subtotal ni Excel? Awọn data ti a ṣe ayẹwo Countif pẹlu awọn ilana nipasẹ awọn iṣẹ Excel Ninu sẹẹli ofo tẹ agbekalẹ = SUMPRODUCT (SUBTOTAL (3, OFFSET (B2: B18, ROW (B2: B18) -MIN (ROW (B2: B18)) ,, 1))), ISNUMBER (Ṣawari ('Pear', B2: B18)) + 0), ki o tẹ bọtini Tẹ.