{"id":38354,"date":"2026-09-08T16:45:40","date_gmt":"2026-09-08T15:45:40","guid":{"rendered":"https:\/\/keyfy.com\/blog\/%cf%80%cf%8e%cf%82-%ce%bd%ce%b1-%ce%bc%ce%b5%cf%84%cf%81%ce%ae%cf%83%ce%b5%cf%84%ce%b5-%cf%84%ce%b1-%cf%80%ce%bb%ce%b1%ce%af%cf%83%ce%b9%ce%b1-%ce%b5%cf%80%ce%b9%ce%bb%ce%bf%ce%b3%ce%ae%cf%82-%cf%83\/"},"modified":"2026-09-08T16:45:40","modified_gmt":"2026-09-08T15:45:40","slug":"%cf%80%cf%8e%cf%82-%ce%bd%ce%b1-%ce%bc%ce%b5%cf%84%cf%81%ce%ae%cf%83%ce%b5%cf%84%ce%b5-%cf%84%ce%b1-%cf%80%ce%bb%ce%b1%ce%af%cf%83%ce%b9%ce%b1-%ce%b5%cf%80%ce%b9%ce%bb%ce%bf%ce%b3%ce%ae%cf%82-%cf%83","status":"publish","type":"post","link":"https:\/\/keyfy.com\/el\/blog\/%cf%80%cf%8e%cf%82-%ce%bd%ce%b1-%ce%bc%ce%b5%cf%84%cf%81%ce%ae%cf%83%ce%b5%cf%84%ce%b5-%cf%84%ce%b1-%cf%80%ce%bb%ce%b1%ce%af%cf%83%ce%b9%ce%b1-%ce%b5%cf%80%ce%b9%ce%bb%ce%bf%ce%b3%ce%ae%cf%82-%cf%83\/","title":{"rendered":"\u03a0\u03ce\u03c2 \u03bd\u03b1 \u03bc\u03b5\u03c4\u03c1\u03ae\u03c3\u03b5\u03c4\u03b5 \u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c3\u03c4\u03bf Excel \u03bc\u03b5 \u03c4\u03c1\u03cc\u03c0\u03bf \u03c0\u03bf\u03c5 \u03bd\u03b1 \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03b5\u03af \u03c0\u03c1\u03b1\u03b3\u03bc\u03b1\u03c4\u03b9\u03ba\u03ac"},"content":{"rendered":"<p>\u03a6\u03b1\u03bd\u03c4\u03b1\u03c3\u03c4\u03b5\u03af\u03c4\u03b5 \u03ad\u03bd\u03b1 \u03b5\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03bf \u03c0\u03b1\u03c1\u03b1\u03ba\u03bf\u03bb\u03bf\u03cd\u03b8\u03b7\u03c3\u03b7\u03c2 \u03ad\u03c1\u03b3\u03bf\u03c5 \u03bc\u03b5 60 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b5\u03c2, \u03ba\u03b1\u03b8\u03b5\u03bc\u03af\u03b1 \u03b1\u03c0\u03cc \u03c4\u03b9\u03c2 \u03bf\u03c0\u03bf\u03af\u03b5\u03c2 \u03c0\u03b5\u03c1\u03b9\u03bb\u03b1\u03bc\u03b2\u03ac\u03bd\u03b5\u03b9 \u03ad\u03bd\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c0\u03bf\u03c5 \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf\u03c2 \u03c4\u03c3\u03b5\u03ba\u03ac\u03c1\u03b5\u03b9 \u03ba\u03b1\u03b8\u03ce\u03c2 \u03b7 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03bf\u03bb\u03bf\u03ba\u03bb\u03b7\u03c1\u03ce\u03bd\u03b5\u03c4\u03b1\u03b9. \u039f \u03c5\u03c0\u03b5\u03cd\u03b8\u03c5\u03bd\u03bf\u03c2 \u03b8\u03ad\u03bb\u03b5\u03b9 \u03bd\u03b1 \u03b2\u03bb\u03ad\u03c0\u03b5\u03b9 \u03ad\u03bd\u03b1\u03bd \u03bc\u03cc\u03bd\u03bf \u03b1\u03c1\u03b9\u03b8\u03bc\u03cc \u03c3\u03c4\u03b7\u03bd \u03ba\u03bf\u03c1\u03c5\u03c6\u03ae: \u03c0\u03cc\u03c3\u03b5\u03c2 \u03ad\u03c7\u03bf\u03c5\u03bd \u03c0\u03c1\u03ac\u03b3\u03bc\u03b1\u03c4\u03b9 \u03bf\u03bb\u03bf\u03ba\u03bb\u03b7\u03c1\u03c9\u03b8\u03b5\u03af. \u0388\u03c4\u03c3\u03b9, \u03b5\u03b9\u03c3\u03ac\u03b3\u03b5\u03b9 \u03ad\u03bd\u03b1\u03bd \u03c4\u03cd\u03c0\u03bf COUNTIF, \u03c4\u03bf\u03bd \u03ba\u03b1\u03c4\u03b5\u03c5\u03b8\u03cd\u03bd\u03b5\u03b9 \u03c3\u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03ba\u03b1\u03b9 \u03bb\u03b1\u03bc\u03b2\u03ac\u03bd\u03b5\u03b9 \u03c9\u03c2 \u03b1\u03c0\u03bf\u03c4\u03ad\u03bb\u03b5\u03c3\u03bc\u03b1 \u03c4\u03bf \u03bc\u03b7\u03b4\u03ad\u03bd. \u039a\u03ac\u03b8\u03b5 \u03c6\u03bf\u03c1\u03ac. \u0391\u03ba\u03cc\u03bc\u03b1 \u03ba\u03b1\u03b9 \u03cc\u03c4\u03b1\u03bd \u03c4\u03b1 \u03bc\u03b9\u03c3\u03ac \u03ba\u03bf\u03c5\u03c4\u03ac\u03ba\u03b9\u03b1 \u03b5\u03af\u03bd\u03b1\u03b9 \u03c3\u03b1\u03c6\u03ce\u03c2 \u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03bc\u03ad\u03bd\u03b1.    <\/p>\n<p>\u0391\u03c5\u03c4\u03cc \u03b5\u03af\u03bd\u03b1\u03b9 \u03c4\u03bf \u03c3\u03b7\u03bc\u03b5\u03af\u03bf \u03c0\u03bf\u03c5 \u03c3\u03c7\u03b5\u03b4\u03cc\u03bd \u03cc\u03bb\u03bf\u03b9 \u03bf\u03b9 \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03c0\u03b1\u03c1\u03b1\u03bb\u03b5\u03af\u03c0\u03bf\u03c5\u03bd. \u0388\u03bd\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c0\u03bf\u03c5 \u03b2\u03c1\u03af\u03c3\u03ba\u03b5\u03c4\u03b1\u03b9 \u03c3\u03b5 \u03ad\u03bd\u03b1 \u03c6\u03cd\u03bb\u03bb\u03bf \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2 \u03b4\u03b5\u03bd \u03b5\u03af\u03bd\u03b1\u03b9 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03bf \u2014 \u03b5\u03af\u03bd\u03b1\u03b9 \u03ad\u03bd\u03b1 \u00ab\u03b1\u03b9\u03c9\u03c1\u03bf\u03cd\u03bc\u03b5\u03bd\u03bf\u00bb \u03b1\u03bd\u03c4\u03b9\u03ba\u03b5\u03af\u03bc\u03b5\u03bd\u03bf, \u03cc\u03c0\u03c9\u03c2 \u03ad\u03bd\u03b1 \u03c3\u03c7\u03ae\u03bc\u03b1 \u03ae \u03bc\u03b9\u03b1 \u03b5\u03b9\u03ba\u03cc\u03bd\u03b1, \u03ba\u03b1\u03b9 \u03ad\u03bd\u03b1\u03c2 \u03c4\u03cd\u03c0\u03bf\u03c2 \u03b4\u03b5\u03bd \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03c4\u03bf \u00ab\u03b4\u03b9\u03b1\u03b2\u03ac\u03c3\u03b5\u03b9\u00bb. \u03a0\u03c1\u03bf\u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5 \u03bd\u03b1 \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03ae\u03c3\u03b5\u03b9 \u03bf\u03c0\u03bf\u03b9\u03b1\u03b4\u03ae\u03c0\u03bf\u03c4\u03b5 \u03bc\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7, \u03ba\u03ac\u03b8\u03b5 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03c3\u03c5\u03bd\u03b4\u03b5\u03b8\u03b5\u03af \u03bc\u03b5 \u03ad\u03bd\u03b1 \u03ba\u03b5\u03bb\u03af, \u03ad\u03c4\u03c3\u03b9 \u03ce\u03c3\u03c4\u03b5 \u03cc\u03c4\u03b1\u03bd \u03c4\u03bf \u03b5\u03c0\u03b9\u03bb\u03ad\u03be\u03b5\u03c4\u03b5 \u03bd\u03b1 \u03b5\u03bc\u03c6\u03b1\u03bd\u03af\u03b6\u03b5\u03c4\u03b1\u03b9 \u03ba\u03ac\u03c4\u03c9 \u03b1\u03c0\u03cc \u03b1\u03c5\u03c4\u03cc \u03ba\u03ac\u03c4\u03b9 \u03b1\u03bd\u03b1\u03b3\u03bd\u03ce\u03c3\u03b9\u03bc\u03bf. \u0391\u03c5\u03c4\u03cc \u03b5\u03af\u03bd\u03b1\u03b9 \u03c4\u03bf \u03c0\u03c1\u03b1\u03b3\u03bc\u03b1\u03c4\u03b9\u03ba\u03cc \u03b5\u03bc\u03c0\u03cc\u03b4\u03b9\u03bf. \u0391\u03c5\u03c4\u03cc\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 \u03bf \u03bb\u03cc\u03b3\u03bf\u03c2 \u03b3\u03b9\u03b1 \u03c4\u03bf\u03bd \u03bf\u03c0\u03bf\u03af\u03bf \u03bf\u03b9 \u03c3\u03c5\u03bc\u03b2\u03bf\u03c5\u03bb\u03ad\u03c2 \u03b3\u03b9\u03b1 \u03c4\u03b7 \u03c7\u03c1\u03ae\u03c3\u03b7 \u03c4\u03b7\u03c2 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7\u03c2 COUNTIF \u03b1\u03c0\u03bf\u03c4\u03c5\u03b3\u03c7\u03ac\u03bd\u03bf\u03c5\u03bd \u03b3\u03b9\u03b1 \u03c4\u03bf\u03c5\u03c2 \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03bf\u03c5\u03c2 \u03c7\u03c1\u03ae\u03c3\u03c4\u03b5\u03c2 \u03c0\u03bf\u03c5 \u03b1\u03bd\u03b1\u03b6\u03b7\u03c4\u03bf\u03cd\u03bd <strong>\u03c0\u03ce\u03c2 \u03bd\u03b1 \u03bc\u03b5\u03c4\u03c1\u03ae\u03c3\u03bf\u03c5\u03bd \u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c3\u03c4\u03bf Excel<\/strong> \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b7 \u03c3\u03c5\u03bd\u03ad\u03c7\u03b5\u03b9\u03b1 \u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03bf\u03c5\u03bd \u03b1\u03bc\u03ad\u03c3\u03c9\u03c2 \u03c3\u03c4\u03bf Google.    <\/p>\n<p>\u039c\u03cc\u03bb\u03b9\u03c2 \u03b4\u03b9\u03b5\u03c5\u03b8\u03b5\u03c4\u03b7\u03b8\u03b5\u03af \u03b7 \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7, \u03b7 \u03af\u03b4\u03b9\u03b1 \u03b7 \u03bc\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7 \u03b4\u03b9\u03b1\u03c1\u03ba\u03b5\u03af \u03c0\u03b5\u03c1\u03af\u03c0\u03bf\u03c5 \u03b4\u03ad\u03ba\u03b1 \u03b4\u03b5\u03c5\u03c4\u03b5\u03c1\u03cc\u03bb\u03b5\u03c0\u03c4\u03b1. \u0391\u03c2 \u03b4\u03b9\u03b5\u03c5\u03b8\u03b5\u03c4\u03ae\u03c3\u03bf\u03c5\u03bc\u03b5 \u03bb\u03bf\u03b9\u03c0\u03cc\u03bd \u03c0\u03c1\u03ce\u03c4\u03b1 \u03c4\u03b7\u03bd \u03c0\u03c1\u03bf\u03cb\u03c0\u03cc\u03b8\u03b5\u03c3\u03b7 \u03ba\u03b1\u03b9 \u03bc\u03b5\u03c4\u03ac \u03b1\u03c2 \u03b5\u03c6\u03b1\u03c1\u03bc\u03cc\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c4\u03bf\u03bd \u03c4\u03cd\u03c0\u03bf. <\/p>\n<div class=\"pb-tldr\" style=\"background: #eef2ff; border-left: 4px solid #007aff; border-radius: 8px; padding: 16px 20px; margin: 24px 0;\">\n<div style=\"font-weight: bold; color: #4f46e5; font-size: 13px; letter-spacing: 1.5px; margin-bottom: 6px;\">\u03a3\u03cd\u03bd\u03c4\u03bf\u03bc\u03b7 \u03c0\u03b5\u03c1\u03af\u03bb\u03b7\u03c8\u03b7 (TLDR)<\/div>\n<div style=\"color: #1f2937;\">\u0397 \u03bc\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7 \u03c4\u03c9\u03bd \u03c0\u03bb\u03b1\u03b9\u03c3\u03af\u03c9\u03bd \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c3\u03c4\u03bf Excel \u03b5\u03be\u03b1\u03c1\u03c4\u03ac\u03c4\u03b1\u03b9 \u03b1\u03c0\u03cc \u03ad\u03bd\u03b1 \u03c3\u03c4\u03bf\u03b9\u03c7\u03b5\u03af\u03bf \u03c0\u03bf\u03c5 \u03bf\u03b9 \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03bf\u03b9 \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03c0\u03b1\u03c1\u03b1\u03b2\u03bb\u03ad\u03c0\u03bf\u03c5\u03bd: \u03ba\u03ac\u03b8\u03b5 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03b5\u03af\u03bd\u03b1\u03b9 \u03c3\u03c5\u03bd\u03b4\u03b5\u03b4\u03b5\u03bc\u03ad\u03bd\u03bf \u03bc\u03b5 \u03ad\u03bd\u03b1 \u03ba\u03b5\u03bb\u03af, \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 \u03c4\u03b7\u03bd \u03c4\u03b9\u03bc\u03ae TRUE \u03ae FALSE. \u03a7\u03c9\u03c1\u03af\u03c2 \u03b1\u03c5\u03c4\u03ae \u03c4\u03b7 \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7, \u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 COUNTIF \u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 \u03bc\u03b7\u03b4\u03ad\u03bd, \u03b1\u03bd\u03b5\u03be\u03ac\u03c1\u03c4\u03b7\u03c4\u03b1 \u03b1\u03c0\u03cc \u03c4\u03bf\u03bd \u03b1\u03c1\u03b9\u03b8\u03bc\u03cc \u03c4\u03c9\u03bd \u03c0\u03bb\u03b1\u03b9\u03c3\u03af\u03c9\u03bd \u03c0\u03bf\u03c5 \u03ad\u03c7\u03bf\u03c5\u03bd \u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03b5\u03af. \u03a3\u03c5\u03bd\u03b4\u03ad\u03c3\u03c4\u03b5 \u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 (\u03c5\u03c0\u03ac\u03c1\u03c7\u03b5\u03b9 \u03bc\u03b9\u03b1 \u03bc\u03ad\u03b8\u03bf\u03b4\u03bf\u03c2 \u03bc\u03b1\u03b6\u03b9\u03ba\u03ae\u03c2 \u03b5\u03c0\u03b5\u03be\u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2 \u03b3\u03b9\u03b1 \u03b4\u03b5\u03ba\u03ac\u03b4\u03b5\u03c2 \u03c4\u03b1\u03c5\u03c4\u03cc\u03c7\u03c1\u03bf\u03bd\u03b1) \u03ba\u03b1\u03b9, \u03c3\u03c4\u03b7 \u03c3\u03c5\u03bd\u03ad\u03c7\u03b5\u03b9\u03b1, \u03b5\u03ba\u03c4\u03b5\u03bb\u03ad\u03c3\u03c4\u03b5 \u03c4\u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 \u00ab <code>=COUNTIF(range,TRUE)<\/code> \u00bb \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03bc\u03b5\u03c4\u03c1\u03ae\u03c3\u03b5\u03c4\u03b5 \u03b1\u03bc\u03ad\u03c3\u03c9\u03c2 \u03c4\u03b1 \u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03bc\u03ad\u03bd\u03b1.  <\/div>\n<\/div>\n<h2>\u0393\u03b9\u03b1\u03c4\u03af \u03bf\u03b9 \u03c3\u03c5\u03bd\u03b7\u03b8\u03b9\u03c3\u03bc\u03ad\u03bd\u03b5\u03c2 \u03c3\u03c5\u03bc\u03b2\u03bf\u03c5\u03bb\u03ad\u03c2 \u03b1\u03c0\u03bf\u03c4\u03c5\u03b3\u03c7\u03ac\u03bd\u03bf\u03c5\u03bd<\/h2>\n<p>\u03a4\u03b1 \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03b1 \u03ac\u03c1\u03b8\u03c1\u03b1 \u03be\u03b5\u03ba\u03b9\u03bd\u03bf\u03cd\u03bd \u03bc\u03b5 \u03c4\u03b7 \u03c6\u03cc\u03c1\u03bc\u03bf\u03c5\u03bb\u03b1. \u00ab\u03a0\u03bb\u03b7\u03ba\u03c4\u03c1\u03bf\u03bb\u03bf\u03b3\u03ae\u03c3\u03c4\u03b5 <code>=COUNTIF(B2:B60,TRUE)<\/code> \u00bb, \u03bb\u03ad\u03bd\u03b5, \u03ba\u03b1\u03b9 \u03c3\u03c5\u03bd\u03b5\u03c7\u03af\u03b6\u03bf\u03c5\u03bd, \u03c5\u03c0\u03bf\u03b8\u03ad\u03c4\u03bf\u03bd\u03c4\u03b1\u03c2 \u03cc\u03c4\u03b9 \u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03c3\u03c5\u03bc\u03c0\u03bb\u03b7\u03c1\u03ce\u03bd\u03bf\u03c5\u03bd \u03ae\u03b4\u03b7 \u03ad\u03bd\u03b1 \u03ba\u03b5\u03bb\u03af. \u0393\u03b9\u03b1 \u03bc\u03b9\u03b1 \u03bc\u03b9\u03ba\u03c1\u03ae \u03bc\u03b5\u03c1\u03af\u03b4\u03b1 \u03b1\u03bd\u03b1\u03b3\u03bd\u03c9\u03c3\u03c4\u03ce\u03bd \u03c0\u03bf\u03c5 \u03c1\u03c5\u03b8\u03bc\u03af\u03b6\u03bf\u03c5\u03bd \u03c4\u03b1 \u03c0\u03c1\u03ac\u03b3\u03bc\u03b1\u03c4\u03b1 \u03c0\u03c1\u03bf\u03c3\u03b5\u03ba\u03c4\u03b9\u03ba\u03ac, \u03b4\u03b5\u03bd \u03c5\u03c0\u03ac\u03c1\u03c7\u03b5\u03b9 \u03c0\u03c1\u03cc\u03b2\u03bb\u03b7\u03bc\u03b1. \u038c\u03bb\u03bf\u03b9 \u03bf\u03b9 \u03ac\u03bb\u03bb\u03bf\u03b9 \u03bb\u03b1\u03bc\u03b2\u03ac\u03bd\u03bf\u03c5\u03bd \u03ad\u03bd\u03b1 \u03b1\u03c0\u03bb\u03cc \u03bc\u03b7\u03b4\u03ad\u03bd \u03ba\u03b1\u03b9 \u03ba\u03b1\u03bc\u03af\u03b1 \u03b5\u03be\u03ae\u03b3\u03b7\u03c3\u03b7.   <\/p>\n<p>\u039f \u03bb\u03cc\u03b3\u03bf\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 \u03b4\u03bf\u03bc\u03b9\u03ba\u03cc\u03c2. \u0388\u03bd\u03b1 <strong>\u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c4\u03bf\u03c5 Form Control<\/strong> \u03ae \u03ad\u03bd\u03b1 <strong>\u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 ActiveX<\/strong> \u03b5\u03bc\u03c6\u03b1\u03bd\u03af\u03b6\u03b5\u03c4\u03b1\u03b9 \u03c3\u03b5 \u03ad\u03bd\u03b1 \u03b5\u03c0\u03af\u03c0\u03b5\u03b4\u03bf \u03c3\u03c7\u03b5\u03b4\u03af\u03b1\u03c3\u03b7\u03c2 \u03c0\u03ac\u03bd\u03c9 \u03b1\u03c0\u03cc \u03c4\u03bf \u03c0\u03bb\u03ad\u03b3\u03bc\u03b1. \u0388\u03c7\u03b5\u03b9 \u03bc\u03b9\u03b1 \u03bf\u03c0\u03c4\u03b9\u03ba\u03ae \u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u2014 \u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03bc\u03ad\u03bd\u03bf \u03ae \u03bc\u03b7 \u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03bc\u03ad\u03bd\u03bf \u2014, \u03b1\u03bb\u03bb\u03ac \u03b1\u03c5\u03c4\u03ae \u03b7 \u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03c3\u03c5\u03bd\u03b4\u03ad\u03b5\u03c4\u03b1\u03b9 \u03bc\u03b5 \u03c4\u03bf \u03af\u03b4\u03b9\u03bf \u03c4\u03bf \u03b1\u03bd\u03c4\u03b9\u03ba\u03b5\u03af\u03bc\u03b5\u03bd\u03bf \u03ba\u03b1\u03b9 \u03cc\u03c7\u03b9 \u03bc\u03b5 \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf \u03ba\u03b5\u03bb\u03af \u03c3\u03c4\u03bf \u03bf\u03c0\u03bf\u03af\u03bf \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03b1\u03bd\u03b1\u03c6\u03ad\u03c1\u03b5\u03c4\u03b1\u03b9 \u03bf \u03c4\u03cd\u03c0\u03bf\u03c2 \u03c3\u03b1\u03c2. \u03a4\u03bf Excel \u03b1\u03bd\u03c4\u03b9\u03bc\u03b5\u03c4\u03c9\u03c0\u03af\u03b6\u03b5\u03b9 \u03c4\u03bf \u03c3\u03cd\u03bd\u03bf\u03bb\u03bf \u03c9\u03c2 \u03b4\u03b9\u03b1\u03ba\u03bf\u03c3\u03bc\u03b7\u03c4\u03b9\u03ba\u03cc \u03c3\u03c4\u03bf\u03b9\u03c7\u03b5\u03af\u03bf, \u03bc\u03ad\u03c7\u03c1\u03b9 \u03bd\u03b1 \u03c4\u03bf\u03c5 \u03c5\u03c0\u03bf\u03b4\u03b5\u03af\u03be\u03b5\u03c4\u03b5 \u03c4\u03bf \u03b1\u03bd\u03c4\u03af\u03b8\u03b5\u03c4\u03bf.   <\/p>\n<p>\u039f\u03b9 \u03bd\u03b5\u03cc\u03c4\u03b5\u03c1\u03b5\u03c2 \u03b5\u03ba\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2 \u03c0\u03b5\u03c1\u03b9\u03c0\u03bb\u03ad\u03ba\u03bf\u03c5\u03bd \u03b1\u03ba\u03cc\u03bc\u03b7 \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03bf \u03c4\u03bf \u03b8\u03ad\u03bc\u03b1. \u03a4\u03bf Excel \u03b3\u03b9\u03b1 \u03c4\u03bf Microsoft 365 \u03c0\u03c1\u03cc\u03c3\u03b8\u03b5\u03c3\u03b5 \u03c4\u03bf 2024 \u03ad\u03bd\u03b1 \u03b5\u03bd\u03c3\u03c9\u03bc\u03b1\u03c4\u03c9\u03bc\u03ad\u03bd\u03bf \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c0\u03bf\u03c5 \u03b5\u03b9\u03c3\u03ac\u03b3\u03b5\u03c4\u03b1\u03b9 \u03b1\u03c0\u03b5\u03c5\u03b8\u03b5\u03af\u03b1\u03c2 \u03c3\u03b5 \u03ad\u03bd\u03b1 \u03ba\u03b5\u03bb\u03af \u03ba\u03b1\u03b9 \u03b1\u03c0\u03bf\u03b8\u03b7\u03ba\u03b5\u03cd\u03b5\u03b9 \u03c4\u03b9\u03c2 \u03c4\u03b9\u03bc\u03ad\u03c2 TRUE \u03ae FALSE \u03b1\u03ba\u03c1\u03b9\u03b2\u03ce\u03c2 \u03b5\u03ba\u03b5\u03af, \u03c7\u03c9\u03c1\u03af\u03c2 \u03bd\u03b1 \u03b1\u03c0\u03b1\u03b9\u03c4\u03b5\u03af\u03c4\u03b1\u03b9 \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7. \u03a9\u03c3\u03c4\u03cc\u03c3\u03bf, \u03b5\u03ba\u03b1\u03c4\u03bf\u03bc\u03bc\u03cd\u03c1\u03b9\u03b1 \u03b2\u03b9\u03b2\u03bb\u03af\u03b1 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2 \u03b5\u03be\u03b1\u03ba\u03bf\u03bb\u03bf\u03c5\u03b8\u03bf\u03cd\u03bd \u03bd\u03b1 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03bf\u03cd\u03bd \u03c0\u03b1\u03bb\u03b1\u03b9\u03cc\u03c4\u03b5\u03c1\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03bb\u03ad\u03b3\u03c7\u03bf\u03c5 \u03c6\u03cc\u03c1\u03bc\u03b1\u03c2, \u03b5\u03bd\u03ce \u03c0\u03bf\u03bb\u03bb\u03bf\u03af \u03c7\u03c1\u03ae\u03c3\u03c4\u03b5\u03c2 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03bf\u03cd\u03bd \u03c4\u03bf Excel 2019 \u03ae \u03c4\u03bf 2021, \u03cc\u03c0\u03bf\u03c5 \u03b7 \u03b5\u03bd\u03c3\u03c9\u03bc\u03b1\u03c4\u03c9\u03bc\u03ad\u03bd\u03b7 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae \u03b4\u03b5\u03bd \u03c5\u03c0\u03ac\u03c1\u03c7\u03b5\u03b9. \u03a4\u03bf \u03b8\u03ad\u03bc\u03b1 \u03b5\u03af\u03bd\u03b1\u03b9 \u03cc\u03c4\u03b9, \u03b1\u03bd \u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03bb\u03ad\u03b3\u03c7\u03bf\u03c5 \u03c3\u03b1\u03c2 \u03c0\u03c1\u03bf\u03c3\u03c4\u03ad\u03b8\u03b7\u03ba\u03b1\u03bd \u03bc\u03b5 \u03c4\u03bf\u03bd \u03c0\u03b1\u03bb\u03b9\u03cc \u03c4\u03c1\u03cc\u03c0\u03bf \u03ae \u03ba\u03bb\u03b7\u03c1\u03bf\u03bd\u03bf\u03bc\u03ae\u03b8\u03b7\u03ba\u03b1\u03bd \u03b1\u03c0\u03cc \u03c4\u03bf \u03b1\u03c1\u03c7\u03b5\u03af\u03bf \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf\u03c5 \u03ac\u03bb\u03bb\u03bf\u03c5, \u03b7 \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7 \u03b4\u03b5\u03bd \u03b5\u03af\u03bd\u03b1\u03b9 \u03c0\u03c1\u03bf\u03b1\u03b9\u03c1\u03b5\u03c4\u03b9\u03ba\u03ae.   <\/p>\n<h2>\u03a3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7 \u03b5\u03bd\u03cc\u03c2 \u03c0\u03bb\u03b1\u03b9\u03c3\u03af\u03bf\u03c5 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03bc\u03b5 \u03ad\u03bd\u03b1 \u03ba\u03b5\u03bb\u03af, \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 TRUE \u03ae FALSE<\/h2>\n<p>\u0391\u03c5\u03c4\u03cc \u03b5\u03af\u03bd\u03b1\u03b9 \u03c4\u03bf \u03b2\u03ae\u03bc\u03b1 \u03c0\u03bf\u03c5 \u03ba\u03ac\u03bd\u03b5\u03b9 \u03cc\u03bb\u03b7 \u03c4\u03b7 \u03bc\u03ad\u03b8\u03bf\u03b4\u03bf \u03bc\u03b5 \u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c4\u03bf\u03c5 Excel (true\/false) \u03bd\u03b1 \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03b5\u03af. \u038c\u03c4\u03b1\u03bd \u03ad\u03bd\u03b1 \u03c3\u03c5\u03bd\u03b4\u03b5\u03b4\u03b5\u03bc\u03ad\u03bd\u03bf \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 \u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03bc\u03ad\u03bd\u03bf, \u03c4\u03bf \u03ba\u03b5\u03bb\u03af-\u03c0\u03c1\u03bf\u03bf\u03c1\u03b9\u03c3\u03bc\u03cc\u03c2 \u03c4\u03bf\u03c5 \u03b5\u03bc\u03c6\u03b1\u03bd\u03af\u03b6\u03b5\u03b9 \u03c4\u03b7\u03bd \u03c4\u03b9\u03bc\u03ae TRUE. \u0391\u03bd \u03b4\u03b5\u03bd \u03b5\u03af\u03bd\u03b1\u03b9 \u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03bc\u03ad\u03bd\u03bf, \u03b5\u03bc\u03c6\u03b1\u03bd\u03af\u03b6\u03b5\u03b9 \u03c4\u03b7\u03bd \u03c4\u03b9\u03bc\u03ae FALSE. \u0391\u03c5\u03c4\u03ad\u03c2 \u03bf\u03b9 \u03c4\u03b9\u03bc\u03ad\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 \u03c0\u03bf\u03c5 \u03c5\u03c0\u03bf\u03bb\u03bf\u03b3\u03af\u03b6\u03b5\u03b9 \u03bf \u03c4\u03cd\u03c0\u03bf\u03c2.   <\/p>\n<p>\u0394\u03b5\u03af\u03c4\u03b5 \u03c0\u03b1\u03c1\u03b1\u03ba\u03ac\u03c4\u03c9 \u03c0\u03ce\u03c2 \u03bc\u03c0\u03bf\u03c1\u03b5\u03af\u03c4\u03b5 \u03bd\u03b1 \u03c3\u03c5\u03bd\u03b4\u03ad\u03c3\u03b5\u03c4\u03b5 \u03ad\u03bd\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03bc\u03b5 \u03ad\u03bd\u03b1 \u03ba\u03b5\u03bb\u03af \u03c4\u03bf\u03c5 Excel \u03b3\u03b9\u03b1 \u03ad\u03bd\u03b1 \u03bc\u03b5\u03bc\u03bf\u03bd\u03c9\u03bc\u03ad\u03bd\u03bf \u03c3\u03c4\u03bf\u03b9\u03c7\u03b5\u03af\u03bf \u03b5\u03bb\u03ad\u03b3\u03c7\u03bf\u03c5 \u03c6\u03cc\u03c1\u03bc\u03b1\u03c2:<\/p>\n<ol>\n<li>\u039a\u03ac\u03bd\u03c4\u03b5 \u03b4\u03b5\u03be\u03af \u03ba\u03bb\u03b9\u03ba \u03c3\u03c4\u03bf \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03ba\u03b1\u03b9 \u03b5\u03c0\u03b9\u03bb\u03ad\u03be\u03c4\u03b5 <strong>\u00ab\u039c\u03bf\u03c1\u03c6\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03c3\u03c4\u03bf\u03b9\u03c7\u03b5\u03af\u03bf\u03c5 \u03b5\u03bb\u03ad\u03b3\u03c7\u03bf\u03c5<\/strong>\u00bb.<\/li>\n<li>\u0391\u03bd\u03bf\u03af\u03be\u03c4\u03b5 \u03c4\u03b7\u03bd \u03ba\u03b1\u03c1\u03c4\u03ad\u03bb\u03b1 <strong>\u00ab\u0388\u03bb\u03b5\u03b3\u03c7\u03bf\u03c2<\/strong> \u00bb.<\/li>\n<li>\u03a3\u03c4\u03bf \u03c0\u03b5\u03b4\u03af\u03bf <strong>\u00ab\u03a3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7 \u03ba\u03b5\u03bb\u03b9\u03bf\u03cd\u00bb<\/strong>, \u03ba\u03ac\u03bd\u03c4\u03b5 \u03ba\u03bb\u03b9\u03ba \u03c3\u03c4\u03bf \u03ba\u03b5\u03bb\u03af \u03c3\u03c4\u03bf \u03bf\u03c0\u03bf\u03af\u03bf \u03b8\u03ad\u03bb\u03b5\u03c4\u03b5 \u03bd\u03b1 \u03ba\u03b1\u03c4\u03b1\u03c7\u03c9\u03c1\u03b7\u03b8\u03b5\u03af \u03c4\u03bf \u03b1\u03c0\u03bf\u03c4\u03ad\u03bb\u03b5\u03c3\u03bc\u03b1 (\u03c3\u03c5\u03bd\u03ae\u03b8\u03c9\u03c2 \u03c4\u03bf \u03ba\u03b5\u03bb\u03af \u03c0\u03bf\u03c5 \u03b2\u03c1\u03af\u03c3\u03ba\u03b5\u03c4\u03b1\u03b9 \u03b1\u03ba\u03c1\u03b9\u03b2\u03ce\u03c2 \u03c0\u03af\u03c3\u03c9 \u03ae \u03b4\u03af\u03c0\u03bb\u03b1 \u03c3\u03c4\u03bf \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf).<\/li>\n<li>\u039a\u03ac\u03bd\u03c4\u03b5 \u03ba\u03bb\u03b9\u03ba <strong>\u03c3\u03c4\u03bf \u00abOK<\/strong>\u00bb.<\/li>\n<\/ol>\n<p>\u0395\u03c0\u03b9\u03bb\u03ad\u03be\u03c4\u03b5 \u03c4\u03bf \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03c4\u03ce\u03c1\u03b1 \u03ba\u03b1\u03b9 \u03c4\u03bf \u03c3\u03c5\u03bd\u03b4\u03b5\u03b4\u03b5\u03bc\u03ad\u03bd\u03bf \u03ba\u03b5\u03bb\u03af \u03b8\u03b1 \u03b1\u03bb\u03bb\u03ac\u03be\u03b5\u03b9 \u03c3\u03b5 TRUE. \u0391\u03c0\u03bf\u03b5\u03c0\u03b9\u03bb\u03ad\u03be\u03c4\u03b5 \u03c4\u03bf \u03ba\u03b1\u03b9 \u03b8\u03b1 \u03b5\u03bc\u03c6\u03b1\u03bd\u03b9\u03c3\u03c4\u03b5\u03af \u03c4\u03bf FALSE. \u0395\u03c0\u03b1\u03bd\u03b1\u03bb\u03ac\u03b2\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 \u03b3\u03b9\u03b1 \u03ba\u03ac\u03b8\u03b5 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2, \u03c3\u03c5\u03bd\u03b4\u03ad\u03bf\u03bd\u03c4\u03b1\u03c2 \u03c4\u03bf \u03ba\u03b1\u03b8\u03ad\u03bd\u03b1 \u03bc\u03b5 \u03c4\u03b7 \u03b4\u03b9\u03ba\u03ae \u03c4\u03bf\u03c5 \u03c3\u03b5\u03b9\u03c1\u03ac, \u03ce\u03c3\u03c4\u03b5 \u03c4\u03b1 \u03b1\u03c0\u03bf\u03c4\u03b5\u03bb\u03ad\u03c3\u03bc\u03b1\u03c4\u03b1 \u03bd\u03b1 \u03c3\u03c5\u03c3\u03c3\u03c9\u03c1\u03b5\u03cd\u03bf\u03bd\u03c4\u03b1\u03b9 \u03c3\u03b5 \u03bc\u03b9\u03b1 \u03c4\u03b1\u03ba\u03c4\u03bf\u03c0\u03bf\u03b9\u03b7\u03bc\u03ad\u03bd\u03b7 \u03c3\u03c4\u03ae\u03bb\u03b7.  <\/p>\n<div class=\"pb-tipbox pb-tipbox-tip\" style=\"background: #ecfdf5; border-left: 4px solid #10b981; border-radius: 8px; padding: 14px 18px; margin: 24px 0;\">\n<div style=\"font-weight: bold; color: #047857; font-size: 13px; letter-spacing: 1px; margin-bottom: 5px;\">\u03a3\u03a5\u039c\u0392\u039f\u03a5\u039b\u0397<\/div>\n<div style=\"color: #1f2937;\">\u03a3\u03c5\u03bd\u03b4\u03ad\u03c3\u03c4\u03b5 \u03ba\u03ac\u03b8\u03b5 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03bc\u03b5 \u03c4\u03bf \u03ba\u03b5\u03bb\u03af \u03c3\u03c4\u03bf \u03bf\u03c0\u03bf\u03af\u03bf \u03b2\u03c1\u03af\u03c3\u03ba\u03b5\u03c4\u03b1\u03b9 \u03ba\u03b1\u03b9, \u03c3\u03c4\u03b7 \u03c3\u03c5\u03bd\u03ad\u03c7\u03b5\u03b9\u03b1, \u03bf\u03c1\u03af\u03c3\u03c4\u03b5 \u03c4\u03bf \u03c7\u03c1\u03ce\u03bc\u03b1 \u03c4\u03b7\u03c2 \u03b3\u03c1\u03b1\u03bc\u03bc\u03b1\u03c4\u03bf\u03c3\u03b5\u03b9\u03c1\u03ac\u03c2 \u03b1\u03c5\u03c4\u03bf\u03cd \u03c4\u03bf\u03c5 \u03ba\u03b5\u03bb\u03b9\u03bf\u03cd \u03c3\u03b5 \u03bb\u03b5\u03c5\u03ba\u03cc \u03ae \u03c3\u03cd\u03c1\u03b5\u03c4\u03b5 \u03b5\u03bb\u03b1\u03c6\u03c1\u03ce\u03c2 \u03c4\u03bf \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03c4\u03bf \u03ba\u03b1\u03bb\u03cd\u03c8\u03b5\u03b9. \u03a4\u03bf \u03ba\u03b5\u03af\u03bc\u03b5\u03bd\u03bf TRUE\/FALSE \u03c0\u03b1\u03c1\u03b1\u03bc\u03ad\u03bd\u03b5\u03b9 \u03ba\u03c1\u03c5\u03bc\u03bc\u03ad\u03bd\u03bf, \u03b1\u03bb\u03bb\u03ac \u03c0\u03b1\u03c1\u03b1\u03bc\u03ad\u03bd\u03b5\u03b9 \u03c0\u03bb\u03ae\u03c1\u03c9\u03c2 \u03b1\u03bd\u03b1\u03b3\u03bd\u03ce\u03c3\u03b9\u03bc\u03bf \u03b1\u03c0\u03cc \u03c4\u03bf\u03c5\u03c2 \u03c4\u03cd\u03c0\u03bf\u03c5\u03c2 \u03c3\u03b1\u03c2. <\/div>\n<\/div>\n<p>\u039f \u03bf\u03b4\u03b7\u03b3\u03cc\u03c2 \u03c4\u03bf\u03c5 How-To Geek \u03b3\u03b9\u03b1 <a href=\"https:\/\/www.howtogeek.com\/835206\/how-to-count-checkboxes-in-microsoft-excel\/\" rel=\"nofollow noopener\" target=\"_blank\">\u03c4\u03b7\u03bd \u03ba\u03b1\u03c4\u03b1\u03bc\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7 \u03c4\u03c9\u03bd \u03c0\u03bb\u03b1\u03b9\u03c3\u03af\u03c9\u03bd \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c3\u03c4\u03bf Microsoft Excel<\/a> \u03b5\u03c0\u03b9\u03b2\u03b5\u03b2\u03b1\u03b9\u03ce\u03bd\u03b5\u03b9 \u03c4\u03b7\u03bd \u03af\u03b4\u03b9\u03b1 \u03c3\u03b5\u03b9\u03c1\u03ac: \u03c0\u03c1\u03ce\u03c4\u03b1 \u03b7 \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7, \u03bc\u03b5\u03c4\u03ac \u03b7 \u03ba\u03b1\u03c4\u03b1\u03bc\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7. \u03a4\u03bf \u03bd\u03b1 \u03c0\u03b1\u03c1\u03b1\u03bb\u03b5\u03af\u03c0\u03b5\u03b9 \u03ba\u03b1\u03bd\u03b5\u03af\u03c2 \u03c4\u03b7 \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7 \u03b5\u03af\u03bd\u03b1\u03b9 \u03c4\u03bf \u03c0\u03b9\u03bf \u03c3\u03c5\u03bd\u03b7\u03b8\u03b9\u03c3\u03bc\u03ad\u03bd\u03bf \u03bb\u03ac\u03b8\u03bf\u03c2, \u03ba\u03b1\u03b9 \u03b1\u03c5\u03c4\u03cc\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 \u03bf \u03bb\u03cc\u03b3\u03bf\u03c2 \u03b3\u03b9\u03b1 \u03c4\u03bf\u03bd \u03bf\u03c0\u03bf\u03af\u03bf \u03bf\u03b9 \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03c0\u03bf\u03c5 \u03b4\u03af\u03bd\u03bf\u03c5\u03bd \u03c0\u03c1\u03bf\u03c4\u03b5\u03c1\u03b1\u03b9\u03cc\u03c4\u03b7\u03c4\u03b1 \u03c3\u03c4\u03bf\u03bd \u03c4\u03cd\u03c0\u03bf \u03bf\u03b4\u03b7\u03b3\u03bf\u03cd\u03bd \u03c4\u03bf\u03c5\u03c2 \u03c7\u03c1\u03ae\u03c3\u03c4\u03b5\u03c2 \u03c3\u03b5 \u03b1\u03b4\u03b9\u03ad\u03be\u03bf\u03b4\u03bf. <\/p>\n<h2>\u0397 \u03bc\u03ad\u03b8\u03bf\u03b4\u03bf\u03c2 \u03bc\u03b1\u03b6\u03b9\u03ba\u03ae\u03c2 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03b3\u03b9\u03b1 \u03b4\u03b5\u03ba\u03ac\u03b4\u03b5\u03c2 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2<\/h2>\n<p>\u0397 \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7 60 \u03ba\u03b5\u03bb\u03b9\u03ce\u03bd \u03ad\u03bd\u03b1 \u03c0\u03c1\u03bf\u03c2 \u03ad\u03bd\u03b1 \u03bc\u03ad\u03c3\u03c9 \u03c4\u03bf\u03c5 \u00ab\u0395\u03bb\u03ad\u03b3\u03c7\u03bf\u03c5 \u03bc\u03bf\u03c1\u03c6\u03ae\u03c2\u00bb \u03b5\u03af\u03bd\u03b1\u03b9 \u03b5\u03be\u03b1\u03b9\u03c1\u03b5\u03c4\u03b9\u03ba\u03ac \u03ba\u03bf\u03c5\u03c1\u03b1\u03c3\u03c4\u03b9\u03ba\u03ae. \u039a\u03b1\u03bd\u03b5\u03af\u03c2 \u03b4\u03b5\u03bd \u03b8\u03ad\u03bb\u03b5\u03b9 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03b9 \u03b4\u03b5\u03be\u03af \u03ba\u03bb\u03b9\u03ba \u03b5\u03be\u03ae\u03bd\u03c4\u03b1 \u03c6\u03bf\u03c1\u03ad\u03c2. \u03a5\u03c0\u03ac\u03c1\u03c7\u03bf\u03c5\u03bd \u03b4\u03cd\u03bf \u03c4\u03b1\u03c7\u03cd\u03c4\u03b5\u03c1\u03bf\u03b9 \u03c4\u03c1\u03cc\u03c0\u03bf\u03b9, \u03b1\u03bd\u03ac\u03bb\u03bf\u03b3\u03b1 \u03bc\u03b5 \u03c4\u03bf\u03bd \u03c4\u03c1\u03cc\u03c0\u03bf \u03c0\u03bf\u03c5 \u03ad\u03c7\u03b5\u03b9 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03b7\u03b8\u03b5\u03af \u03c4\u03bf \u03c6\u03cd\u03bb\u03bb\u03bf \u03c3\u03b1\u03c2.  <\/p>\n<p>\u0391\u03bd \u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c3\u03b1\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 \u03ae\u03b4\u03b7 \u03c4\u03b1\u03ba\u03c4\u03bf\u03c0\u03bf\u03b9\u03b7\u03bc\u03ad\u03bd\u03b1 \u03c3\u03b5 \u03bc\u03b9\u03b1 \u03c3\u03c4\u03ae\u03bb\u03b7, \u03bf \u03c0\u03b9\u03bf \u03b3\u03c1\u03ae\u03b3\u03bf\u03c1\u03bf\u03c2 \u03c4\u03c1\u03cc\u03c0\u03bf\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 \u03bd\u03b1 \u03c3\u03c5\u03bd\u03b4\u03ad\u03c3\u03b5\u03c4\u03b5 \u03c4\u03bf \u03c0\u03c1\u03ce\u03c4\u03bf \u03c7\u03b5\u03b9\u03c1\u03bf\u03ba\u03af\u03bd\u03b7\u03c4\u03b1 \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b7 \u03c3\u03c5\u03bd\u03ad\u03c7\u03b5\u03b9\u03b1 \u03bd\u03b1 \u03c3\u03c5\u03bd\u03b5\u03c7\u03af\u03c3\u03b5\u03c4\u03b5 \u03c0\u03c1\u03bf\u03c2 \u03c4\u03b1 \u03ba\u03ac\u03c4\u03c9. \u03a9\u03c3\u03c4\u03cc\u03c3\u03bf, \u03c4\u03bf Excel \u03b4\u03b5\u03bd \u03b1\u03c5\u03be\u03ac\u03bd\u03b5\u03b9 \u03b1\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b1 \u03c4\u03bf\u03c5\u03c2 \u03c3\u03c5\u03bd\u03b4\u03ad\u03c3\u03bc\u03bf\u03c5\u03c2 \u03c4\u03c9\u03bd \u03ba\u03b5\u03bb\u03b9\u03ce\u03bd \u03cc\u03c4\u03b1\u03bd \u03b1\u03bd\u03c4\u03b9\u03b3\u03c1\u03ac\u03c6\u03b5\u03c4\u03b5 \u03ad\u03bd\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03bb\u03ad\u03b3\u03c7\u03bf\u03c5 \u03c6\u03cc\u03c1\u03bc\u03b1\u03c2 \u2014 \u03c0\u03c1\u03ac\u03b3\u03bc\u03b1 \u03c0\u03bf\u03c5 \u03c3\u03b7\u03bc\u03b1\u03af\u03bd\u03b5\u03b9 \u03cc\u03c4\u03b9 \u03b7 \u03c0\u03c1\u03b1\u03b3\u03bc\u03b1\u03c4\u03b9\u03ba\u03ae \u03bc\u03b1\u03b6\u03b9\u03ba\u03ae \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7 \u03c3\u03c5\u03bd\u03ae\u03b8\u03c9\u03c2 \u03b1\u03c0\u03b1\u03b9\u03c4\u03b5\u03af \u03c4\u03b7 \u03c7\u03c1\u03ae\u03c3\u03b7 \u03bc\u03b9\u03b1\u03c2 \u03c3\u03cd\u03bd\u03c4\u03bf\u03bc\u03b7\u03c2 \u03bc\u03b1\u03ba\u03c1\u03bf\u03b5\u03bd\u03c4\u03bf\u03bb\u03ae\u03c2. <\/p>\n<p>\u0391\u03bd\u03bf\u03af\u03be\u03c4\u03b5 \u03c4\u03bf\u03bd \u03b5\u03c0\u03b5\u03be\u03b5\u03c1\u03b3\u03b1\u03c3\u03c4\u03ae VBA \u03bc\u03b5 \u03c4\u03bf \u03c3\u03c5\u03bd\u03b4\u03c5\u03b1\u03c3\u03bc\u03cc \u03c0\u03bb\u03ae\u03ba\u03c4\u03c1\u03c9\u03bd Alt + F11, \u03c0\u03c1\u03bf\u03c3\u03b8\u03ad\u03c3\u03c4\u03b5 \u03bc\u03b9\u03b1 \u03b5\u03bd\u03cc\u03c4\u03b7\u03c4\u03b1 \u03ba\u03b1\u03b9 \u03b5\u03c0\u03b9\u03ba\u03bf\u03bb\u03bb\u03ae\u03c3\u03c4\u03b5 \u03ba\u03ac\u03c4\u03b9 \u03c0\u03b1\u03c1\u03cc\u03bc\u03bf\u03b9\u03bf \u03bc\u03b5 \u03b1\u03c5\u03c4\u03cc:<\/p>\n<pre><code class=\"vba language-vba\">Sub LinkCheckboxes()\n    Dim cb As CheckBox\n    For Each cb In ActiveSheet.CheckBoxes\n        cb.LinkedCell = cb.TopLeftCell.Offset(0, 1).Address\n    Next cb\nEnd Sub\n<\/code><\/pre>\n<p>\u0395\u03ba\u03c4\u03b5\u03bb\u03ad\u03c3\u03c4\u03b5 \u03c4\u03b7 \u03bc\u03af\u03b1 \u03c6\u03bf\u03c1\u03ac \u03ba\u03b1\u03b9 \u03ba\u03ac\u03b8\u03b5 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03bb\u03ad\u03b3\u03c7\u03bf\u03c5 \u03c4\u03bf\u03c5 Form Control \u03b8\u03b1 \u03c3\u03c5\u03bd\u03b4\u03b5\u03b8\u03b5\u03af \u03bc\u03b5 \u03c4\u03bf \u03ba\u03b5\u03bb\u03af \u03c0\u03bf\u03c5 \u03b2\u03c1\u03af\u03c3\u03ba\u03b5\u03c4\u03b1\u03b9 \u03bc\u03af\u03b1 \u03c3\u03c4\u03ae\u03bb\u03b7 \u03c0\u03b9\u03bf \u03b4\u03b5\u03be\u03b9\u03ac. \u03a0\u03c1\u03bf\u03c3\u03b1\u03c1\u03bc\u03cc\u03c3\u03c4\u03b5 \u03c4\u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 \u00ab <code>Offset(0, 1)<\/code> \u00bb \u03b1\u03bd \u03b8\u03ad\u03bb\u03b5\u03c4\u03b5 \u03c4\u03bf \u03b1\u03c0\u03bf\u03c4\u03ad\u03bb\u03b5\u03c3\u03bc\u03b1 \u03bd\u03b1 \u03b5\u03bc\u03c6\u03b1\u03bd\u03af\u03b6\u03b5\u03c4\u03b1\u03b9 \u03b1\u03bb\u03bb\u03bf\u03cd: \u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 \u00ab <code>Offset(0, -1)<\/code> \u00bb \u03b3\u03c1\u03ac\u03c6\u03b5\u03b9 \u03b1\u03c1\u03b9\u03c3\u03c4\u03b5\u03c1\u03ac, \u03b5\u03bd\u03ce \u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 \u00ab <code>Offset(0, 0)<\/code> \u00bb \u03b3\u03c1\u03ac\u03c6\u03b5\u03b9 \u03c3\u03c4\u03bf \u03ba\u03b5\u03bb\u03af \u03c0\u03bf\u03c5 \u03b2\u03c1\u03af\u03c3\u03ba\u03b5\u03c4\u03b1\u03b9 \u03b1\u03ba\u03c1\u03b9\u03b2\u03ce\u03c2 \u03c0\u03af\u03c3\u03c9 \u03b1\u03c0\u03cc \u03c4\u03bf \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf. \u039f \u03bf\u03b4\u03b7\u03b3\u03cc\u03c2 \u03c4\u03bf\u03c5 ExtendOffice \u03b3\u03b9\u03b1 <a href=\"https:\/\/www.extendoffice.com\/documents\/excel\/2460-excel-sum-count-checkboxes.html\" rel=\"nofollow noopener\" target=\"_blank\">\u03c4\u03bf\u03bd \u03c5\u03c0\u03bf\u03bb\u03bf\u03b3\u03b9\u03c3\u03bc\u03cc \u03c4\u03bf\u03c5 \u03b1\u03b8\u03c1\u03bf\u03af\u03c3\u03bc\u03b1\u03c4\u03bf\u03c2 \u03ba\u03b1\u03b9 \u03c4\u03bf\u03c5 \u03b1\u03c1\u03b9\u03b8\u03bc\u03bf\u03cd \u03c4\u03c9\u03bd \u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03bc\u03ad\u03bd\u03c9\u03bd \u03c0\u03bb\u03b1\u03b9\u03c3\u03af\u03c9\u03bd \u03b5\u03bb\u03ad\u03b3\u03c7\u03bf\u03c5<\/a> \u03c0\u03b5\u03c1\u03b9\u03b3\u03c1\u03ac\u03c6\u03b5\u03b9 \u03bc\u03b9\u03b1 \u03c0\u03b1\u03c1\u03cc\u03bc\u03bf\u03b9\u03b1 \u03c0\u03c1\u03bf\u03c3\u03ad\u03b3\u03b3\u03b9\u03c3\u03b7 \u03bc\u03b5 \u03bc\u03b1\u03ba\u03c1\u03bf\u03b5\u03bd\u03c4\u03bf\u03bb\u03ad\u03c2 \u03b3\u03b9\u03b1 \u03bc\u03b5\u03b3\u03b1\u03bb\u03cd\u03c4\u03b5\u03c1\u03b1 \u03c6\u03cd\u03bb\u03bb\u03b1.  <\/p>\n<p>\u0394\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03b5\u03af\u03c4\u03b5 \u03c4\u03bf\u03bd \u03b9\u03c7\u03bd\u03b7\u03bb\u03ac\u03c4\u03b7 \u03b1\u03c0\u03cc \u03c4\u03b7\u03bd \u03b1\u03c1\u03c7\u03ae \u03c3\u03c4\u03bf Microsoft 365; \u03a0\u03b1\u03c1\u03b1\u03bb\u03b5\u03af\u03c8\u03c4\u03b5 \u03cc\u03bb\u03b1 \u03b1\u03c5\u03c4\u03ac. \u0395\u03c0\u03b9\u03bb\u03ad\u03be\u03c4\u03b5 \u03c4\u03bf \u03b5\u03cd\u03c1\u03bf\u03c2 \u03c3\u03b1\u03c2, \u03bc\u03b5\u03c4\u03b1\u03b2\u03b5\u03af\u03c4\u03b5 \u03c3\u03c4\u03b7\u03bd <strong>\u03b5\u03bd\u03c4\u03bf\u03bb\u03ae \u00ab\u0395\u03b9\u03c3\u03b1\u03b3\u03c9\u03b3\u03ae\u00bb ( &gt; ) \u00ab\u03a0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2\u00bb (Checkbox<\/strong>) \u03ba\u03b1\u03b9 \u03c4\u03bf Excel \u03b8\u03b1 \u03c4\u03bf\u03c0\u03bf\u03b8\u03b5\u03c4\u03ae\u03c3\u03b5\u03b9 \u03b5\u03b3\u03b3\u03b5\u03bd\u03ae \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c0\u03bf\u03c5 \u03c0\u03b5\u03c1\u03b9\u03ad\u03c7\u03bf\u03c5\u03bd \u03ae\u03b4\u03b7 \u03c4\u03b9\u03c2 \u03c4\u03b9\u03bc\u03ad\u03c2 TRUE\/FALSE \u03c3\u03c4\u03b1 \u03ba\u03b5\u03bb\u03b9\u03ac. \u03a7\u03c9\u03c1\u03af\u03c2 \u03c3\u03c5\u03bd\u03b4\u03ad\u03c3\u03bc\u03bf\u03c5\u03c2, \u03c7\u03c9\u03c1\u03af\u03c2 \u03bc\u03b1\u03ba\u03c1\u03bf\u03b5\u03bd\u03c4\u03bf\u03bb\u03ad\u03c2. \u03a4\u03bf \u03c3\u03b5\u03bc\u03b9\u03bd\u03ac\u03c1\u03b9\u03bf \u03c4\u03bf\u03c5 DataCamp \u03c3\u03c7\u03b5\u03c4\u03b9\u03ba\u03ac \u03bc\u03b5 <a href=\"https:\/\/www.datacamp.com\/tutorial\/excel-checkbox\" rel=\"nofollow noopener\" target=\"_blank\">\u03c4\u03b7\u03bd \u03c0\u03c1\u03bf\u03c3\u03b8\u03ae\u03ba\u03b7, \u03c4\u03b7 \u03c7\u03c1\u03ae\u03c3\u03b7 \u03ba\u03b1\u03b9 \u03c4\u03b7\u03bd \u03ba\u03b1\u03c4\u03b1\u03bc\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7 \u03c0\u03bb\u03b1\u03b9\u03c3\u03af\u03c9\u03bd \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2<\/a> \u03c0\u03b1\u03c1\u03bf\u03c5\u03c3\u03b9\u03ac\u03b6\u03b5\u03b9 \u03bb\u03b5\u03c0\u03c4\u03bf\u03bc\u03b5\u03c1\u03ce\u03c2 \u03c4\u03b7 \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03c4\u03b7\u03c2 \u03b5\u03b3\u03b3\u03b5\u03bd\u03bf\u03cd\u03c2 \u03ad\u03ba\u03b4\u03bf\u03c3\u03b7\u03c2.    <\/p>\n<h2>\u03a0\u03ce\u03c2 \u03bd\u03b1 \u03bc\u03b5\u03c4\u03c1\u03ae\u03c3\u03b5\u03c4\u03b5 \u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c3\u03c4\u03bf Excel \u03bc\u03b5 \u03c4\u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 COUNTIF<\/h2>\n<p>\u03a4\u03ce\u03c1\u03b1 \u03c4\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03bf \u03bc\u03ad\u03c1\u03bf\u03c2. \u039c\u03b5 \u03c4\u03b7 \u03c3\u03c4\u03ae\u03bb\u03b7 \u00ab\u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03bc\u03bf\u03c2\u00bb \u03b3\u03b5\u03bc\u03ac\u03c4\u03b7 \u03bc\u03b5 \u03c4\u03b9\u03bc\u03ad\u03c2 TRUE \u03ba\u03b1\u03b9 FALSE, \u03b7 \u03bc\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7 \u03b3\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 \u03bc\u03b5 \u03ad\u03bd\u03b1\u03bd \u03bc\u03cc\u03bd\u03bf \u03c4\u03cd\u03c0\u03bf. <\/p>\n<p>\u0393\u03b9\u03b1 \u03bd\u03b1 \u03bc\u03b5\u03c4\u03c1\u03ae\u03c3\u03b5\u03b9 \u03c4\u03b1 \u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03bc\u03ad\u03bd\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2, \u03c4\u03bf Excel \u03b4\u03b5\u03bd \u03c7\u03c1\u03b5\u03b9\u03ac\u03b6\u03b5\u03c4\u03b1\u03b9 \u03c4\u03af\u03c0\u03bf\u03c4\u03b1 \u03c0\u03b9\u03bf \u03c0\u03b5\u03c1\u03af\u03c0\u03bb\u03bf\u03ba\u03bf \u03b1\u03c0\u03cc:<\/p>\n<pre><code>=COUNTIF(B2:B60,TRUE)\n<\/code><\/pre>\n<p>\u0391\u03c5\u03c4\u03cc \u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 \u03c4\u03bf\u03bd \u03b1\u03c1\u03b9\u03b8\u03bc\u03cc \u03c4\u03c9\u03bd \u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03bc\u03ad\u03bd\u03c9\u03bd \u03c0\u03bb\u03b1\u03b9\u03c3\u03af\u03c9\u03bd. \u0391\u03bd\u03c4\u03b9\u03ba\u03b1\u03c4\u03b1\u03c3\u03c4\u03ae\u03c3\u03c4\u03b5 \u03c4\u03bf TRUE \u03bc\u03b5 FALSE \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03bc\u03b5\u03c4\u03c1\u03ae\u03c3\u03b5\u03c4\u03b5 \u03c4\u03b1 \u03bc\u03b7 \u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03bc\u03ad\u03bd\u03b1: <\/p>\n<pre><code>=COUNTIF(B2:B60,FALSE)\n<\/code><\/pre>\n<p>\u0398\u03ad\u03bb\u03b5\u03c4\u03b5 \u03bd\u03b1 \u03c5\u03c0\u03bf\u03bb\u03bf\u03b3\u03af\u03c3\u03b5\u03c4\u03b5 \u03c4\u03bf \u03c0\u03bf\u03c3\u03bf\u03c3\u03c4\u03cc \u03bf\u03bb\u03bf\u03ba\u03bb\u03ae\u03c1\u03c9\u03c3\u03b7\u03c2 \u03b3\u03b9\u03b1 \u03b1\u03c5\u03c4\u03cc\u03bd \u03c4\u03bf\u03bd \u03c0\u03af\u03bd\u03b1\u03ba\u03b1 \u03c0\u03b1\u03c1\u03b1\u03ba\u03bf\u03bb\u03bf\u03cd\u03b8\u03b7\u03c3\u03b7\u03c2 \u03ad\u03c1\u03b3\u03c9\u03bd; \u0394\u03b9\u03b1\u03b9\u03c1\u03ad\u03c3\u03c4\u03b5 \u03c4\u03bf\u03bd \u03b1\u03c1\u03b9\u03b8\u03bc\u03cc \u03c4\u03c9\u03bd \u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03c4\u03bf\u03b9\u03c7\u03b5\u03af\u03c9\u03bd \u03bc\u03b5 \u03c4\u03bf \u03c3\u03cd\u03bd\u03bf\u03bb\u03bf: <\/p>\n<pre><code>=COUNTIF(B2:B60,TRUE)\/COUNTA(B2:B60)\n<\/code><\/pre>\n<p>\u0394\u03b9\u03b1\u03bc\u03bf\u03c1\u03c6\u03ce\u03c3\u03c4\u03b5 \u03c4\u03bf \u03b1\u03c0\u03bf\u03c4\u03ad\u03bb\u03b5\u03c3\u03bc\u03b1 \u03c9\u03c2 \u03c0\u03bf\u03c3\u03bf\u03c3\u03c4\u03cc \u03ba\u03b1\u03b9 \u03b8\u03b1 \u03ad\u03c7\u03b5\u03c4\u03b5 \u03bc\u03b9\u03b1 \u03b6\u03c9\u03bd\u03c4\u03b1\u03bd\u03ae \u03ad\u03bd\u03b4\u03b5\u03b9\u03be\u03b7 \u03c0\u03c1\u03bf\u03cc\u03b4\u03bf\u03c5 \u03c0\u03bf\u03c5 \u03b5\u03bd\u03b7\u03bc\u03b5\u03c1\u03ce\u03bd\u03b5\u03c4\u03b1\u03b9 \u03b1\u03bc\u03ad\u03c3\u03c9\u03c2 \u03bc\u03cc\u03bb\u03b9\u03c2 \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf\u03c2 \u03b5\u03c0\u03b9\u03bb\u03ad\u03be\u03b5\u03b9 \u03ad\u03bd\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf. \u0397 \u03c7\u03c1\u03ae\u03c3\u03b7 \u03c4\u03b7\u03c2 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7\u03c2 COUNTIF \u03bc\u03b5 \u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 \u03c0\u03c1\u03b1\u03b3\u03bc\u03b1\u03c4\u03b9\u03ba\u03ac \u03c4\u03cc\u03c3\u03bf \u03b1\u03c0\u03bb\u03ae, \u03b1\u03c1\u03ba\u03b5\u03af \u03bd\u03b1 \u03c5\u03c0\u03ac\u03c1\u03c7\u03bf\u03c5\u03bd \u03bf\u03b9 \u03c4\u03b9\u03bc\u03ad\u03c2 \u03c0\u03bf\u03c5 \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03bc\u03b5\u03c4\u03c1\u03b7\u03b8\u03bf\u03cd\u03bd. <\/p>\n<div class=\"pb-stats\" style=\"display: flex; gap: 14px; flex-wrap: wrap; margin: 24px 0;\">\n<div style=\"flex: 1; min-width: 150px; background: #f9fafb; border: 1px solid #e5e7eb; border-radius: 10px; padding: 18px 14px; text-align: center;\">\n<div style=\"font-size: 24px; font-weight: 800; color: #4f46e5; line-height: 1.2;\">1 \u03c6\u03cc\u03c1\u03bc\u03bf\u03c5\u03bb\u03b1<\/div>\n<div style=\"font-size: 13px; color: #6b7280; margin-top: 6px;\">\u03b3\u03b9\u03b1 \u03bd\u03b1 \u03b1\u03b8\u03c1\u03bf\u03af\u03c3\u03b5\u03b9 \u03cc\u03bb\u03b1 \u03c4\u03b1 \u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03bc\u03ad\u03bd\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03c3\u03b5 \u03bc\u03b9\u03b1 \u03c0\u03b5\u03c1\u03b9\u03bf\u03c7\u03ae<\/div>\n<\/div>\n<div style=\"flex: 1; min-width: 150px; background: #f9fafb; border: 1px solid #e5e7eb; border-radius: 10px; padding: 18px 14px; text-align: center;\">\n<div style=\"font-size: 24px; font-weight: 800; color: #4f46e5; line-height: 1.2;\">~10 \u03b4\u03b5\u03c5\u03c4\u03b5\u03c1\u03cc\u03bb\u03b5\u03c0\u03c4\u03b1<\/div>\n<div style=\"font-size: 13px; color: #6b7280; margin-top: 6px;\">\u03bd\u03b1 \u03b3\u03c1\u03ac\u03c8\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 COUNTIF \u03bc\u03cc\u03bb\u03b9\u03c2 \u03c3\u03c5\u03bd\u03b4\u03b5\u03b8\u03bf\u03cd\u03bd \u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1<\/div>\n<\/div>\n<div style=\"flex: 1; min-width: 150px; background: #f9fafb; border: 1px solid #e5e7eb; border-radius: 10px; padding: 18px 14px; text-align: center;\">\n<div style=\"font-size: 24px; font-weight: 800; color: #4f46e5; line-height: 1.2;\">0 \u03b1\u03c0\u03bf\u03c4\u03b5\u03bb\u03ad\u03c3\u03bc\u03b1\u03c4\u03b1<\/div>\n<div style=\"font-size: 13px; color: #6b7280; margin-top: 6px;\">\u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03c4\u03b1\u03b9 \u03cc\u03c4\u03b1\u03bd \u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03b4\u03b5\u03bd \u03b5\u03af\u03bd\u03b1\u03b9 \u03c3\u03c5\u03bd\u03b4\u03b5\u03b4\u03b5\u03bc\u03ad\u03bd\u03b1 \u03b1\u03c1\u03c7\u03b9\u03ba\u03ac<\/div>\n<\/div>\n<\/div>\n<p>\u039c\u03b9\u03b1 \u03c0\u03c1\u03bf\u03b5\u03b9\u03b4\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03c3\u03c7\u03b5\u03c4\u03b9\u03ba\u03ac \u03bc\u03b5 \u03c4\u03bf\u03c5\u03c2 \u03c4\u03cd\u03c0\u03bf\u03c5\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd. \u039f\u03b9 \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03bc\u03bf\u03b9 \u03b5\u03bb\u03ad\u03b3\u03c7\u03bf\u03c5 \u03c6\u03cc\u03c1\u03bc\u03b1\u03c2 \u03ba\u03b1\u03c4\u03b1\u03b3\u03c1\u03ac\u03c6\u03bf\u03c5\u03bd \u03c4\u03b9\u03c2 \u03bb\u03ad\u03be\u03b5\u03b9\u03c2 \u00abTRUE\u00bb \u03ba\u03b1\u03b9 \u00abFALSE\u00bb \u03c9\u03c2 \u03bb\u03bf\u03b3\u03b9\u03ba\u03ad\u03c2 \u03c4\u03b9\u03bc\u03ad\u03c2, \u03bf\u03c0\u03cc\u03c4\u03b5 \u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 ` <code>COUNTIF(range,TRUE)<\/code> ` \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03b5\u03af \u03c7\u03c9\u03c1\u03af\u03c2 \u03c0\u03c1\u03bf\u03b2\u03bb\u03ae\u03bc\u03b1\u03c4\u03b1. \u03a9\u03c3\u03c4\u03cc\u03c3\u03bf, \u03b1\u03bd \u03ad\u03bd\u03b1 \u03c3\u03c5\u03bd\u03b4\u03b5\u03b4\u03b5\u03bc\u03ad\u03bd\u03bf \u03ba\u03b5\u03bb\u03af \u03b5\u03bc\u03c6\u03b1\u03bd\u03af\u03b6\u03b5\u03b9 \u03c4\u03bf \u03ba\u03b5\u03af\u03bc\u03b5\u03bd\u03bf \u00ab <code>\"TRUE\"<\/code> \u00bb \u03bc\u03ad\u03c3\u03b1 \u03c3\u03b5 \u03b5\u03b9\u03c3\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03b1\u03bd\u03c4\u03af \u03b3\u03b9\u03b1 \u03bc\u03b9\u03b1 \u03c0\u03c1\u03b1\u03b3\u03bc\u03b1\u03c4\u03b9\u03ba\u03ae \u03bb\u03bf\u03b3\u03b9\u03ba\u03ae \u03c4\u03b9\u03bc\u03ae, \u03b7 \u03bc\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7 \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03b4\u03ce\u03c3\u03b5\u03b9 \u03bb\u03ac\u03b8\u03bf\u03c2 \u03b1\u03c0\u03bf\u03c4\u03ad\u03bb\u03b5\u03c3\u03bc\u03b1. \u038c\u03c4\u03b1\u03bd \u03c3\u03c5\u03bc\u03b2\u03b5\u03af \u03b1\u03c5\u03c4\u03cc, \u03b4\u03b9\u03bf\u03c1\u03b8\u03ce\u03c3\u03c4\u03b5 \u03c4\u03b7 \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7 \u03ae \u03b1\u03bd\u03c4\u03b9\u03c3\u03c4\u03bf\u03b9\u03c7\u03af\u03c3\u03c4\u03b5 \u03c1\u03b7\u03c4\u03ac \u03c4\u03b7 \u03bc\u03bf\u03c1\u03c6\u03ae \u03c4\u03bf\u03c5 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5. \u0397 \u03c3\u03c5\u03bd\u03c4\u03b1\u03b3\u03ae \u03c4\u03bf\u03c5 \u00abExcel Cookbook\u00bb \u03b3\u03b9\u03b1 <a href=\"https:\/\/www.excel-cookbook.com\/recipes\/count-checked-checkboxes\" rel=\"nofollow noopener\" target=\"_blank\">\u03c4\u03b7\u03bd \u03ba\u03b1\u03c4\u03b1\u03bc\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7 \u03c4\u03c9\u03bd \u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03bc\u03ad\u03bd\u03c9\u03bd \u03c0\u03bb\u03b1\u03b9\u03c3\u03af\u03c9\u03bd \u03b5\u03bb\u03ad\u03b3\u03c7\u03bf\u03c5<\/a> \u03c0\u03b1\u03c1\u03ad\u03c7\u03b5\u03b9 \u03bc\u03b9\u03b1 \u03ba\u03b1\u03bb\u03ae \u03b1\u03bd\u03ac\u03bb\u03c5\u03c3\u03b7 \u03c4\u03b7\u03c2 \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03ac\u03c2 \u03bc\u03b5\u03c4\u03b1\u03be\u03cd \u03bb\u03bf\u03b3\u03b9\u03ba\u03ae\u03c2 \u03c4\u03b9\u03bc\u03ae\u03c2 \u03ba\u03b1\u03b9 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5.    <\/p>\n<h2>\u0391\u03bd\u03c4\u03b9\u03bc\u03b5\u03c4\u03ce\u03c0\u03b9\u03c3\u03b7 \u03c3\u03c5\u03bd\u03b7\u03b8\u03b9\u03c3\u03bc\u03ad\u03bd\u03c9\u03bd \u03c0\u03c1\u03bf\u03b2\u03bb\u03b7\u03bc\u03ac\u03c4\u03c9\u03bd<\/h2>\n<p>\u03a5\u03c0\u03ac\u03c1\u03c7\u03bf\u03c5\u03bd \u03bc\u03b5\u03c1\u03b9\u03ba\u03ac \u03c0\u03c1\u03ac\u03b3\u03bc\u03b1\u03c4\u03b1 \u03c0\u03bf\u03c5 \u03c0\u03c1\u03bf\u03ba\u03b1\u03bb\u03bf\u03cd\u03bd \u03c0\u03c1\u03bf\u03b2\u03bb\u03ae\u03bc\u03b1\u03c4\u03b1 \u03c3\u03c4\u03bf\u03c5\u03c2 \u03c7\u03c1\u03ae\u03c3\u03c4\u03b5\u03c2, \u03b1\u03ba\u03cc\u03bc\u03b1 \u03ba\u03b1\u03b9 \u03cc\u03c4\u03b1\u03bd \u03bf\u03b9 \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03bc\u03bf\u03b9 \u03c6\u03b1\u03af\u03bd\u03bf\u03bd\u03c4\u03b1\u03b9 \u03c3\u03c9\u03c3\u03c4\u03bf\u03af.<\/p>\n<p><strong>\u0397 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 COUNTIF \u03b5\u03be\u03b1\u03ba\u03bf\u03bb\u03bf\u03c5\u03b8\u03b5\u03af \u03bd\u03b1 \u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 \u03bc\u03b7\u03b4\u03ad\u03bd.<\/strong>  \u03a0\u03b9\u03b8\u03b1\u03bd\u03cc\u03c4\u03b1\u03c4\u03b1 \u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b4\u03b5\u03bd \u03b5\u03af\u03c7\u03b1\u03bd \u03c3\u03c5\u03bd\u03b4\u03b5\u03b8\u03b5\u03af \u03c0\u03bf\u03c4\u03ad, \u03ae \u03b7 \u03bc\u03b1\u03ba\u03c1\u03bf\u03b5\u03bd\u03c4\u03bf\u03bb\u03ae \u03b5\u03af\u03c7\u03b5 \u03bf\u03c1\u03af\u03c3\u03b5\u03b9 \u03c4\u03bf\u03c5\u03c2 \u03c3\u03c5\u03bd\u03b4\u03ad\u03c3\u03bc\u03bf\u03c5\u03c2 \u03c3\u03b5 \u03bb\u03ac\u03b8\u03bf\u03c2 \u03c3\u03c4\u03ae\u03bb\u03b7. \u039a\u03ac\u03bd\u03c4\u03b5 \u03ba\u03bb\u03b9\u03ba \u03c3\u03b5 \u03ad\u03bd\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2, \u03b5\u03c0\u03b9\u03bb\u03ad\u03be\u03c4\u03b5 \u03c4\u03bf \u03ba\u03b1\u03b9 \u03c0\u03b1\u03c1\u03b1\u03c4\u03b7\u03c1\u03ae\u03c3\u03c4\u03b5 \u03b1\u03bd \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf \u03ba\u03bf\u03bd\u03c4\u03b9\u03bd\u03cc \u03ba\u03b5\u03bb\u03af \u03b1\u03bb\u03bb\u03ac\u03b6\u03b5\u03b9 \u03c3\u03b5 TRUE. \u0394\u03b5\u03bd \u03b1\u03bb\u03bb\u03ac\u03b6\u03b5\u03b9 \u03c4\u03af\u03c0\u03bf\u03c4\u03b1; \u039f \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03bc\u03bf\u03c2 \u03b4\u03b5\u03bd \u03ad\u03c7\u03b5\u03b9 \u03bf\u03c1\u03b9\u03c3\u03c4\u03b5\u03af.   <\/p>\n<p><strong>\u039f \u03b1\u03c1\u03b9\u03b8\u03bc\u03cc\u03c2 \u03ad\u03c7\u03b5\u03b9 \u03bc\u03b9\u03b1 \u03bc\u03b9\u03ba\u03c1\u03ae \u03b1\u03c0\u03cc\u03ba\u03bb\u03b9\u03c3\u03b7.<\/strong>  \u0395\u03bb\u03ad\u03b3\u03be\u03c4\u03b5 \u03b1\u03bd \u03c5\u03c0\u03ac\u03c1\u03c7\u03bf\u03c5\u03bd \u03ba\u03c1\u03c5\u03bc\u03bc\u03ad\u03bd\u03b1 \u03ae \u03b4\u03b9\u03c0\u03bb\u03ac \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c0\u03bf\u03c5 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03bd\u03c4\u03b1\u03b9 \u03c4\u03bf \u03ad\u03bd\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03bf \u03ac\u03bb\u03bb\u03bf. \u0391\u03bd \u03c3\u03cd\u03c1\u03b5\u03c4\u03b5 \u03b5\u03bb\u03b1\u03c6\u03c1\u03ce\u03c2 \u03ad\u03bd\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf, \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03b5\u03bc\u03c6\u03b1\u03bd\u03b9\u03c3\u03c4\u03b5\u03af \u03ad\u03bd\u03b1 \u03b4\u03b5\u03cd\u03c4\u03b5\u03c1\u03bf \u03c0\u03bf\u03c5 \u03ba\u03c1\u03cd\u03b2\u03b5\u03c4\u03b1\u03b9 \u03b1\u03c0\u03cc \u03ba\u03ac\u03c4\u03c9, \u03ba\u03b1\u03b9 \u03c4\u03b1 \u03b4\u03cd\u03bf \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03c3\u03c5\u03bd\u03b4\u03ad\u03bf\u03bd\u03c4\u03b1\u03b9 \u03bc\u03b5 \u03c4\u03bf \u03af\u03b4\u03b9\u03bf \u03ba\u03b5\u03bb\u03af, \u03bc\u03b5 \u03b1\u03c0\u03bf\u03c4\u03ad\u03bb\u03b5\u03c3\u03bc\u03b1 \u03b7 \u03c4\u03b9\u03bc\u03ae \u03bd\u03b1 \u03ba\u03b1\u03c4\u03b1\u03c7\u03c9\u03c1\u03b7\u03b8\u03b5\u03af \u03b4\u03b9\u03c0\u03bb\u03ac. <\/p>\n<p><strong>\u0391\u03bd\u03b1\u03bc\u03b5\u03b9\u03b3\u03bc\u03ad\u03bd\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03bb\u03ad\u03b3\u03c7\u03bf\u03c5 \u00abNative\u00bb \u03ba\u03b1\u03b9 \u00abForm\u00bb.<\/strong>  \u0391\u03bd \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf\u03c2 \u03c0\u03c1\u03cc\u03c3\u03b8\u03b5\u03c3\u03b5 \u03bc\u03b5\u03c1\u03b9\u03ba\u03ac \u03b5\u03b3\u03b3\u03b5\u03bd\u03ae \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c4\u03bf\u03c5 365 \u03c0\u03b1\u03c1\u03ac\u03bb\u03bb\u03b7\u03bb\u03b1 \u03bc\u03b5 \u03c0\u03b1\u03bb\u03b1\u03b9\u03cc\u03c4\u03b5\u03c1\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03c4\u03bf\u03c5 Form Control, \u03b7 \u03c3\u03c4\u03ae\u03bb\u03b7 \u03c4\u03c9\u03bd \u03c3\u03c5\u03bd\u03b4\u03ad\u03c3\u03bc\u03c9\u03bd \u03c3\u03b1\u03c2 \u03b5\u03bd\u03b4\u03ad\u03c7\u03b5\u03c4\u03b1\u03b9 \u03bd\u03b1 \u03c0\u03b5\u03c1\u03b9\u03ad\u03c7\u03b5\u03b9 \u03ad\u03bd\u03b1 \u03bc\u03b5\u03af\u03b3\u03bc\u03b1 \u03b1\u03c0\u03cc \u03bb\u03bf\u03b3\u03b9\u03ba\u03ad\u03c2 \u03c4\u03b9\u03bc\u03ad\u03c2 \u03b5\u03bd\u03c4\u03cc\u03c2 \u03c4\u03c9\u03bd \u03ba\u03b5\u03bb\u03b9\u03ce\u03bd \u03ba\u03b1\u03b9 \u03ba\u03b5\u03bb\u03b9\u03ac \u03bc\u03b5 \u03be\u03b5\u03c7\u03c9\u03c1\u03b9\u03c3\u03c4\u03bf\u03cd\u03c2 \u03c3\u03c5\u03bd\u03b4\u03ad\u03c3\u03bc\u03bf\u03c5\u03c2. \u03a4\u03c5\u03c0\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03c4\u03b5 \u03c4\u03bf\u03bd \u03c4\u03cd\u03c0\u03bf \u03c0\u03c1\u03b9\u03bd \u03b1\u03c0\u03cc \u03c4\u03b7\u03bd \u03ba\u03b1\u03c4\u03b1\u03bc\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7, \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03b5\u03c4\u03b9\u03ba\u03ac \u03b7 \u03c0\u03b5\u03c1\u03b9\u03bf\u03c7\u03ae \u03c3\u03b1\u03c2 \u03b4\u03b5\u03bd \u03b8\u03b1 \u03b5\u03af\u03bd\u03b1\u03b9 \u03c3\u03c5\u03bd\u03b5\u03c0\u03ae\u03c2. <\/p>\n<p><strong>\u03a4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b1\u03bd\u03c4\u03b9\u03b3\u03c1\u03ac\u03c6\u03b7\u03ba\u03b1\u03bd \u03c7\u03c9\u03c1\u03af\u03c2 \u03c4\u03bf\u03c5\u03c2 \u03c3\u03c5\u03bd\u03b4\u03ad\u03c3\u03bc\u03bf\u03c5\u03c2 \u03c4\u03bf\u03c5\u03c2.<\/strong>  \u038c\u03c4\u03b1\u03bd \u03b1\u03bd\u03c4\u03b9\u03b3\u03c1\u03ac\u03c6\u03b5\u03c4\u03b5 \u03ad\u03bd\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c0\u03bf\u03c5 \u03b5\u03af\u03bd\u03b1\u03b9 \u03c3\u03c5\u03bd\u03b4\u03b5\u03b4\u03b5\u03bc\u03ad\u03bd\u03bf \u03bc\u03b5 \u03ad\u03bd\u03b1 \u03c3\u03c4\u03bf\u03b9\u03c7\u03b5\u03af\u03bf \u03b5\u03bb\u03ad\u03b3\u03c7\u03bf\u03c5 \u03c6\u03cc\u03c1\u03bc\u03b1\u03c2, \u03b7 \u03b1\u03c1\u03c7\u03b9\u03ba\u03ae \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7 \u03b4\u03b9\u03b1\u03c4\u03b7\u03c1\u03b5\u03af\u03c4\u03b1\u03b9, \u03bf\u03c0\u03cc\u03c4\u03b5 \u03ba\u03b1\u03b9 \u03c4\u03b1 \u03c0\u03ad\u03bd\u03c4\u03b5 \u03b1\u03bd\u03c4\u03af\u03b3\u03c1\u03b1\u03c6\u03b1 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bd \u03bd\u03b1 \u03b5\u03b3\u03b3\u03c1\u03ac\u03c8\u03bf\u03c5\u03bd \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03c4\u03bf \u03af\u03b4\u03b9\u03bf \u03ba\u03b5\u03bb\u03af. \u0395\u03ba\u03c4\u03b5\u03bb\u03ad\u03c3\u03c4\u03b5 \u03be\u03b1\u03bd\u03ac \u03c4\u03b7 \u03bc\u03b1\u03ba\u03c1\u03bf\u03b5\u03bd\u03c4\u03bf\u03bb\u03ae \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7\u03c2 \u03bc\u03b5\u03c4\u03ac \u03b1\u03c0\u03cc \u03bf\u03c0\u03bf\u03b9\u03b1\u03b4\u03ae\u03c0\u03bf\u03c4\u03b5 \u03bc\u03b1\u03b6\u03b9\u03ba\u03ae \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 \u03b1\u03bd\u03c4\u03b9\u03b3\u03c1\u03b1\u03c6\u03ae\u03c2-\u03b5\u03c0\u03b9\u03ba\u03cc\u03bb\u03bb\u03b7\u03c3\u03b7\u03c2, \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03b5\u03c0\u03b1\u03bd\u03b1\u03c6\u03ad\u03c1\u03b5\u03c4\u03b5 \u03ba\u03ac\u03b8\u03b5 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03c3\u03c4\u03b7 \u03b4\u03b9\u03ba\u03ae \u03c4\u03bf\u03c5 \u03c3\u03b5\u03b9\u03c1\u03ac. <\/p>\n<div class=\"pb-tipbox pb-tipbox-warning\" style=\"background: #fffbeb; border-left: 4px solid #f59e0b; border-radius: 8px; padding: 14px 18px; margin: 24px 0;\">\n<div style=\"font-weight: bold; color: #b45309; font-size: 13px; letter-spacing: 1px; margin-bottom: 5px;\">\u03a0\u03a1\u039f\u0395\u0399\u0394\u039f\u03a0\u039f\u0399\u0397\u03a3\u0397<\/div>\n<div style=\"color: #1f2937;\">\u03a4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 ActiveX \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03bf\u03cd\u03bd \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03b5\u03c4\u03b9\u03ba\u03ac \u03b1\u03c0\u03cc \u03b1\u03c5\u03c4\u03ac \u03c4\u03bf\u03c5 \u00abForm Control\u00bb \u03ba\u03b1\u03b9 \u03b5\u03bd\u03b4\u03ad\u03c7\u03b5\u03c4\u03b1\u03b9 \u03bd\u03b1 \u03c0\u03b1\u03c1\u03bf\u03c5\u03c3\u03b9\u03ac\u03c3\u03bf\u03c5\u03bd \u03c0\u03c1\u03bf\u03b2\u03bb\u03ae\u03bc\u03b1\u03c4\u03b1 \u03cc\u03c4\u03b1\u03bd \u03ad\u03bd\u03b1 \u03b1\u03c1\u03c7\u03b5\u03af\u03bf \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03b5\u03c4\u03b1\u03b9 \u03b1\u03c0\u03cc \u03c4\u03bf\u03bd \u03ad\u03bd\u03b1\u03bd \u03c5\u03c0\u03bf\u03bb\u03bf\u03b3\u03b9\u03c3\u03c4\u03ae \u03c3\u03c4\u03bf\u03bd \u03ac\u03bb\u03bb\u03bf \u03ae \u03bc\u03b5\u03c4\u03b1\u03be\u03cd \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03b5\u03c4\u03b9\u03ba\u03ce\u03bd \u03b5\u03ba\u03b4\u03cc\u03c3\u03b5\u03c9\u03bd \u03c4\u03bf\u03c5 Excel. \u0393\u03b9\u03b1 \u03ad\u03bd\u03b1 \u03b1\u03c0\u03bb\u03cc \u03c6\u03cd\u03bb\u03bb\u03bf \u03ba\u03b1\u03c4\u03b1\u03bc\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7\u03c2, \u03c0\u03c1\u03bf\u03c4\u03b9\u03bc\u03ae\u03c3\u03c4\u03b5 \u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c4\u03bf\u03c5 \u00abForm Control\u00bb \u03ae \u03c4\u03b1 \u03b5\u03b3\u03b3\u03b5\u03bd\u03ae \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c4\u03bf\u03c5 365, \u03c0\u03c1\u03bf\u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5 \u03bd\u03b1 \u03b1\u03c0\u03bf\u03c6\u03cd\u03b3\u03b5\u03c4\u03b5 \u03c3\u03c6\u03ac\u03bb\u03bc\u03b1\u03c4\u03b1 \u03c0\u03bf\u03c5 \u03c3\u03c7\u03b5\u03c4\u03af\u03b6\u03bf\u03bd\u03c4\u03b1\u03b9 \u03bc\u03b5 \u03c3\u03c5\u03b3\u03ba\u03b5\u03ba\u03c1\u03b9\u03bc\u03ad\u03bd\u03b5\u03c2 \u03b5\u03ba\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2. <\/div>\n<\/div>\n<h2>\u03a3\u03c5\u03c7\u03bd\u03ad\u03c2 \u03b5\u03c1\u03c9\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2<\/h2>\n<p><strong>\u0393\u03b9\u03b1\u03c4\u03af \u03bf \u03c4\u03cd\u03c0\u03bf\u03c2 COUNTIF \u03bc\u03bf\u03c5 \u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 \u03bc\u03b7\u03b4\u03ad\u03bd, \u03b5\u03bd\u03ce \u03c4\u03b1 \u03ba\u03bf\u03c5\u03c4\u03ac\u03ba\u03b9\u03b1 \u03b5\u03af\u03bd\u03b1\u03b9 \u03c3\u03b1\u03c6\u03ce\u03c2 \u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03bc\u03ad\u03bd\u03b1;<\/strong><br \/>\n\u0395\u03c0\u03b5\u03b9\u03b4\u03ae \u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03b4\u03b5\u03bd \u03b5\u03af\u03bd\u03b1\u03b9 \u03c3\u03c5\u03bd\u03b4\u03b5\u03b4\u03b5\u03bc\u03ad\u03bd\u03b1 \u03bc\u03b5 \u03ba\u03b5\u03bb\u03b9\u03ac. \u0388\u03bd\u03b1 \u03c0\u03bb\u03c9\u03c4\u03cc \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03b4\u03b9\u03b1\u03c4\u03b7\u03c1\u03b5\u03af \u03c4\u03b7\u03bd \u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u00ab\u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03bc\u03ad\u03bd\u03bf\u00bb \u03c9\u03c2 \u03b9\u03b4\u03b9\u03cc\u03c4\u03b7\u03c4\u03b1 \u03c4\u03bf\u03c5 \u03b1\u03bd\u03c4\u03b9\u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5, \u03cc\u03c7\u03b9 \u03c9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c0\u03bf\u03c5 \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03b4\u03b9\u03b1\u03b2\u03ac\u03c3\u03b5\u03b9 \u03ad\u03bd\u03b1\u03c2 \u03c4\u03cd\u03c0\u03bf\u03c2. \u03a3\u03c5\u03bd\u03b4\u03ad\u03c3\u03c4\u03b5 \u03c0\u03c1\u03ce\u03c4\u03b1 \u03ba\u03ac\u03b8\u03b5 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03bc\u03b5 \u03ad\u03bd\u03b1 \u03ba\u03b5\u03bb\u03af, \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03ba\u03b1\u03c4\u03b1\u03c7\u03c9\u03c1\u03af\u03b6\u03b5\u03c4\u03b1\u03b9 \u03b7 \u03c4\u03b9\u03bc\u03ae TRUE \u03ae FALSE, \u03ba\u03b1\u03b9 \u03ad\u03c4\u03c3\u03b9 \u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 COUNTIF \u03b8\u03b1 \u03ad\u03c7\u03b5\u03b9 \u03c0\u03c1\u03b1\u03b3\u03bc\u03b1\u03c4\u03b9\u03ba\u03ad\u03c2 \u03c4\u03b9\u03bc\u03ad\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03bc\u03b5\u03c4\u03c1\u03ae\u03c3\u03b5\u03b9.  <\/p>\n<p><strong>\u03a7\u03c1\u03b5\u03b9\u03ac\u03b6\u03bf\u03bc\u03b1\u03b9 \u03ba\u03b1\u03b8\u03cc\u03bb\u03bf\u03c5 \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03bc\u03bf \u03c3\u03c4\u03bf Excel \u03b3\u03b9\u03b1 \u03c4\u03bf Microsoft 365;<\/strong><br \/>\n\u038c\u03c7\u03b9. \u03a4\u03bf \u03b5\u03b3\u03b3\u03b5\u03bd\u03ad\u03c2 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c0\u03bf\u03c5 \u03c0\u03c1\u03bf\u03c3\u03c4\u03ad\u03b8\u03b7\u03ba\u03b5 \u03c4\u03bf 2024 \u03b1\u03c0\u03bf\u03b8\u03b7\u03ba\u03b5\u03cd\u03b5\u03b9 \u03c4\u03b9\u03c2 \u03c4\u03b9\u03bc\u03ad\u03c2 TRUE \u03ae FALSE \u03b1\u03c0\u03b5\u03c5\u03b8\u03b5\u03af\u03b1\u03c2 \u03c3\u03c4\u03bf \u03ba\u03b5\u03bb\u03af \u03c4\u03bf\u03c5, \u03bf\u03c0\u03cc\u03c4\u03b5 \u03bc\u03c0\u03bf\u03c1\u03b5\u03af\u03c4\u03b5 \u03bd\u03b1 \u03b5\u03ba\u03c4\u03b5\u03bb\u03ad\u03c3\u03b5\u03c4\u03b5 \u03b1\u03bc\u03ad\u03c3\u03c9\u03c2 \u03c4\u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 COUNTIF \u03c3\u03c4\u03b7\u03bd \u03c0\u03b5\u03c1\u03b9\u03bf\u03c7\u03ae. \u0397 \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7 \u03b1\u03c0\u03b1\u03b9\u03c4\u03b5\u03af\u03c4\u03b1\u03b9 \u03bc\u03cc\u03bd\u03bf \u03b3\u03b9\u03b1 \u03c4\u03b1 \u03c0\u03b1\u03bb\u03b1\u03b9\u03cc\u03c4\u03b5\u03c1\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c4\u03cd\u03c0\u03bf\u03c5 Form Control \u03ba\u03b1\u03b9 ActiveX.  <\/p>\n<p><strong>\u039c\u03c0\u03bf\u03c1\u03ce \u03bd\u03b1 \u03bc\u03b5\u03c4\u03c1\u03ae\u03c3\u03c9 \u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c7\u03c9\u03c1\u03af\u03c2 \u03bd\u03b1 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03c9 \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf\u03bd \u03c4\u03cd\u03c0\u03bf;<\/strong><br \/>\n\u039c\u03c0\u03bf\u03c1\u03b5\u03af\u03c4\u03b5, \u03c0\u03b5\u03c1\u03af\u03c0\u03bf\u03c5, \u03bd\u03b1 \u03c4\u03bf \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ce\u03bd\u03c4\u03b1\u03c2 \u03ad\u03bd\u03b1 \u03c6\u03af\u03bb\u03c4\u03c1\u03bf \u03ae \u03ba\u03bf\u03b9\u03c4\u03ac\u03b6\u03bf\u03bd\u03c4\u03b1\u03c2 \u03bc\u03b5 \u03c4\u03bf \u03bc\u03ac\u03c4\u03b9 \u03c4\u03b7 \u03c3\u03c4\u03ae\u03bb\u03b7 \u03c4\u03c9\u03bd \u03c3\u03c5\u03bd\u03b4\u03ad\u03c3\u03bc\u03c9\u03bd, \u03b1\u03bb\u03bb\u03ac \u03b1\u03c5\u03c4\u03cc \u03b1\u03bd\u03b1\u03b9\u03c1\u03b5\u03af \u03c4\u03bf \u03bd\u03cc\u03b7\u03bc\u03b1. \u039c\u03b9\u03b1 \u03b1\u03c0\u03bb\u03ae \u03b1\u03bd\u03b1\u03b6\u03ae\u03c4\u03b7\u03c3\u03b7 \u03bc\u03b5 \u03c4\u03b7 \u03c6\u03c1\u03ac\u03c3\u03b7 \u00ab <code>=COUNTIF(range,TRUE)<\/code> \u00bb \u03b4\u03af\u03bd\u03b5\u03b9 \u03ad\u03bd\u03b1\u03bd \u03b6\u03c9\u03bd\u03c4\u03b1\u03bd\u03cc, \u03b1\u03ba\u03c1\u03b9\u03b2\u03ae \u03b1\u03c1\u03b9\u03b8\u03bc\u03cc \u03c0\u03bf\u03c5 \u03b5\u03bd\u03b7\u03bc\u03b5\u03c1\u03ce\u03bd\u03b5\u03c4\u03b1\u03b9 \u03b1\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b1, \u03ba\u03ac\u03c4\u03b9 \u03c0\u03bf\u03c5 \u03b4\u03b5\u03bd \u03c3\u03c5\u03bc\u03b2\u03b1\u03af\u03bd\u03b5\u03b9 \u03bc\u03b5 \u03c4\u03bf \u03c7\u03b5\u03b9\u03c1\u03bf\u03ba\u03af\u03bd\u03b7\u03c4\u03bf \u03c6\u03b9\u03bb\u03c4\u03c1\u03ac\u03c1\u03b9\u03c3\u03bc\u03b1. <\/p>\n<p><strong>\u03a0\u03bf\u03b9\u03bf\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 \u03bf \u03b3\u03c1\u03b7\u03b3\u03bf\u03c1\u03cc\u03c4\u03b5\u03c1\u03bf\u03c2 \u03c4\u03c1\u03cc\u03c0\u03bf\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03c3\u03c5\u03bd\u03b4\u03ad\u03c3\u03c9 50 \u03ae \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2;<\/strong><br \/>\n\u039c\u03b9\u03b1 \u03c3\u03cd\u03bd\u03c4\u03bf\u03bc\u03b7 \u03bc\u03b1\u03ba\u03c1\u03bf\u03b5\u03bd\u03c4\u03bf\u03bb\u03ae VBA \u03c0\u03bf\u03c5 \u03ba\u03ac\u03bd\u03b5\u03b9 \u03b2\u03c1\u03cc\u03c7\u03bf \u03c3\u03b5 \u03ba\u03ac\u03b8\u03b5 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03ba\u03b1\u03b9 \u03bf\u03c1\u03af\u03b6\u03b5\u03b9 \u03ba\u03ac\u03b8\u03b5 \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03bc\u03bf \u03c3\u03b5 \u03ad\u03bd\u03b1 \u03c0\u03b1\u03c1\u03b1\u03ba\u03b5\u03af\u03bc\u03b5\u03bd\u03bf \u03ba\u03b5\u03bb\u03af. \u0395\u03c0\u03b5\u03be\u03b5\u03c1\u03b3\u03ac\u03b6\u03b5\u03c4\u03b1\u03b9 \u03b4\u03b5\u03ba\u03ac\u03b4\u03b5\u03c2 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03bc\u03b5 \u03bc\u03af\u03b1 \u03bc\u03cc\u03bd\u03bf \u03b5\u03ba\u03c4\u03ad\u03bb\u03b5\u03c3\u03b7, \u03b1\u03bd\u03c4\u03af \u03bd\u03b1 \u03c7\u03c1\u03b5\u03b9\u03ac\u03b6\u03b5\u03c4\u03b1\u03b9 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03b4\u03b5\u03be\u03af \u03ba\u03bb\u03b9\u03ba \u03ba\u03b1\u03b9 \u03bd\u03b1 \u03b5\u03c0\u03b9\u03bb\u03ad\u03be\u03b5\u03c4\u03b5 \u00ab\u039c\u03bf\u03c1\u03c6\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03c3\u03c4\u03bf\u03b9\u03c7\u03b5\u03af\u03bf\u03c5 \u03b5\u03bb\u03ad\u03b3\u03c7\u03bf\u03c5\u00bb \u03c0\u03b5\u03bd\u03ae\u03bd\u03c4\u03b1 \u03c6\u03bf\u03c1\u03ad\u03c2 \u03be\u03b5\u03c7\u03c9\u03c1\u03b9\u03c3\u03c4\u03ac. <\/p>\n<p><strong>\u039c\u03ae\u03c0\u03c9\u03c2 \u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 COUNTIF \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03b5\u03af \u03bc\u03b5 \u03c4\u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 SUM;<\/strong><br \/>\n\u039d\u03b1\u03b9. \u0395\u03ac\u03bd \u03c4\u03b1 \u03c3\u03c5\u03bd\u03b4\u03b5\u03b4\u03b5\u03bc\u03ad\u03bd\u03b1 \u03ba\u03b5\u03bb\u03b9\u03ac \u03c0\u03b5\u03c1\u03b9\u03ad\u03c7\u03bf\u03c5\u03bd \u03c4\u03b9\u03c2 \u03c4\u03b9\u03bc\u03ad\u03c2 TRUE\/FALSE, \u03bc\u03c0\u03bf\u03c1\u03b5\u03af\u03c4\u03b5 \u03b5\u03c0\u03af\u03c3\u03b7\u03c2 \u03bd\u03b1 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 \u00ab <code>=SUMPRODUCT(--(B2:B60=TRUE))<\/code> \u00bb \u03b3\u03b9\u03b1 \u03c4\u03b7\u03bd \u03af\u03b4\u03b9\u03b1 \u03ba\u03b1\u03c4\u03b1\u03bc\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7, \u03c4\u03b7\u03bd \u03bf\u03c0\u03bf\u03af\u03b1 \u03bf\u03c1\u03b9\u03c3\u03bc\u03ad\u03bd\u03bf\u03b9 \u03c0\u03c1\u03bf\u03c4\u03b9\u03bc\u03bf\u03cd\u03bd \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03c4\u03b7 \u03c3\u03c5\u03bd\u03b4\u03c5\u03ac\u03c3\u03bf\u03c5\u03bd \u03bc\u03b5 \u03ac\u03bb\u03bb\u03b5\u03c2 \u03c3\u03c5\u03bd\u03b8\u03ae\u03ba\u03b5\u03c2. <\/p>\n<h2>\u03a3\u03c5\u03bc\u03c0\u03ad\u03c1\u03b1\u03c3\u03bc\u03b1<\/h2>\n<p>\u0397 \u03cc\u03bb\u03b7 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 \u03b2\u03b1\u03c3\u03af\u03b6\u03b5\u03c4\u03b1\u03b9 \u03c3\u03b5 \u03bc\u03b9\u03b1 \u03b1\u03ba\u03bf\u03bb\u03bf\u03c5\u03b8\u03af\u03b1 \u03b2\u03b7\u03bc\u03ac\u03c4\u03c9\u03bd \u03c0\u03bf\u03c5 \u03bf\u03b9 \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03bf\u03b9 \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03b1\u03bd\u03c4\u03b9\u03bb\u03b1\u03bc\u03b2\u03ac\u03bd\u03bf\u03bd\u03c4\u03b1\u03b9 \u03b1\u03bd\u03ac\u03c0\u03bf\u03b4\u03b1. \u03a4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 \u03b1\u03bd\u03c4\u03b9\u03ba\u03b5\u03af\u03bc\u03b5\u03bd\u03b1, \u03cc\u03c7\u03b9 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1, \u03bc\u03ad\u03c7\u03c1\u03b9 \u03bd\u03b1 \u03c3\u03c5\u03bd\u03b4\u03ad\u03c3\u03b5\u03c4\u03b5 \u03c4\u03bf \u03ba\u03b1\u03b8\u03ad\u03bd\u03b1 \u03bc\u03b5 \u03ad\u03bd\u03b1 \u03ba\u03b5\u03bb\u03af \u03c0\u03bf\u03c5 \u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 TRUE \u03ae FALSE. \u039c\u03cc\u03bb\u03b9\u03c2 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03b7\u03b8\u03b5\u03af \u03b1\u03c5\u03c4\u03ae \u03b7 \u03c3\u03c4\u03ae\u03bb\u03b7 \u2014\u03b5\u03af\u03c4\u03b5 \u03c7\u03b5\u03b9\u03c1\u03bf\u03ba\u03af\u03bd\u03b7\u03c4\u03b1, \u03b5\u03af\u03c4\u03b5 \u03bc\u03b5 \u03bc\u03b1\u03ba\u03c1\u03bf\u03b5\u03bd\u03c4\u03bf\u03bb\u03ae, \u03b5\u03af\u03c4\u03b5 \u03bc\u03ad\u03c3\u03c9 \u03c4\u03bf\u03c5 \u03b5\u03bd\u03c3\u03c9\u03bc\u03b1\u03c4\u03c9\u03bc\u03ad\u03bd\u03bf\u03c5 \u03c0\u03bb\u03b1\u03b9\u03c3\u03af\u03bf\u03c5 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c4\u03bf\u03c5 365\u2014 \u03bc\u03b9\u03b1 \u03b1\u03c0\u03bb\u03ae \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <code>=COUNTIF(range,TRUE)<\/code> \u03bc\u03b5\u03c4\u03c1\u03ac \u03c4\u03b1 \u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03bc\u03ad\u03bd\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03c3\u03b5 \u03b4\u03b5\u03c5\u03c4\u03b5\u03c1\u03cc\u03bb\u03b5\u03c0\u03c4\u03b1. \u0394\u03b9\u03bf\u03c1\u03b8\u03ce\u03c3\u03c4\u03b5 \u03c4\u03b7\u03bd \u03c0\u03c1\u03bf\u03cb\u03c0\u03cc\u03b8\u03b5\u03c3\u03b7 \u03ba\u03b1\u03b9 \u03bf \u03c4\u03cd\u03c0\u03bf\u03c2 \u03c3\u03c4\u03bf\u03bd \u03bf\u03c0\u03bf\u03af\u03bf \u03cc\u03bb\u03bf\u03b9 \u03ba\u03b1\u03c4\u03b1\u03c6\u03b5\u03cd\u03b3\u03bf\u03c5\u03bd \u03c0\u03c1\u03ce\u03c4\u03b1 \u03b8\u03b1 \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03ae\u03c3\u03b5\u03b9 \u03b5\u03c0\u03b9\u03c4\u03ad\u03bb\u03bf\u03c5\u03c2 \u03cc\u03c0\u03c9\u03c2 \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9. \u0388\u03c4\u03c3\u03b9 \u03bc\u03b5\u03c4\u03c1\u03ac\u03c4\u03b5 \u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c3\u03c4\u03bf Excel \u03c7\u03c9\u03c1\u03af\u03c2 \u03bd\u03b1 \u03c4\u03b1 \u03c4\u03c3\u03b5\u03ba\u03ac\u03c1\u03b5\u03c4\u03b5 \u03ad\u03bd\u03b1 \u03c0\u03c1\u03bf\u03c2 \u03ad\u03bd\u03b1 \u03bc\u03b5 \u03c4\u03bf \u03c7\u03ad\u03c1\u03b9.    <\/p>\n<div class=\"pb-cta\" style=\"background: linear-gradient(160deg,#0f1032 0%,#1e1b4b 45%,#3730a3 100%); border-radius: 18px; padding: 40px 32px; margin: 36px 0; text-align: center;\">\n<div style=\"display: inline-block; color: #c7d2fe; font-size: 11px; font-weight: bold; letter-spacing: 0.08em; text-transform: uppercase; padding: 6px 14px; border-radius: 999px; margin: 0 0 16px;\">\ud83d\ude80 \u0395\u03c0\u03b9\u03c4\u03b1\u03c7\u03cd\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7\u03bd \u03b1\u03bd\u03ac\u03c0\u03c4\u03c5\u03be\u03ae \u03c3\u03b1\u03c2<\/div>\n<div style=\"font-size: 26px; line-height: 1.25; font-weight: 800; color: #ffffff; margin: 0 0 10px;\">\u0391\u03c0\u03bf\u03ba\u03c4\u03ae\u03c3\u03c4\u03b5 \u03bc\u03b9\u03b1 \u03b3\u03bd\u03ae\u03c3\u03b9\u03b1 \u03ac\u03b4\u03b5\u03b9\u03b1 \u03c7\u03c1\u03ae\u03c3\u03b7\u03c2 \u03c4\u03bf\u03c5 Microsoft Office<\/div>\n<div style=\"font-size: 15px; line-height: 1.5; color: #c7d2fe; margin: 0 0 22px; max-width: 640px;\">\u03a7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03c4\u03b5 \u03c4\u03b9\u03c2 \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03af\u03b5\u03c2 \u00ab\u03a0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2\u00bb \u03ba\u03b1\u03b9 \u00abCOUNTIF\u00bb \u03c4\u03bf\u03c5 Excel \u03c3\u03b5 \u03ad\u03bd\u03b1 \u03c0\u03bb\u03ae\u03c1\u03c9\u03c2 \u03b5\u03bd\u03b5\u03c1\u03b3\u03bf\u03c0\u03bf\u03b9\u03b7\u03bc\u03ad\u03bd\u03bf, \u03b3\u03bd\u03ae\u03c3\u03b9\u03bf \u03b1\u03bd\u03c4\u03af\u03b3\u03c1\u03b1\u03c6\u03bf \u03c4\u03bf\u03c5 Office.<\/div>\n<p><a style=\"display: inline-block; background: #4f46e5; color: #ffffff; font-size: 16px; font-weight: bold; text-decoration: none; padding: 15px 32px; border-radius: 999px;\" href=\"https:\/\/keyfy.com\/el\/\">\u0391\u03b3\u03bf\u03c1\u03ac\u03c3\u03c4\u03b5 \u03b3\u03bd\u03ae\u03c3\u03b9\u03b1 \u03ba\u03bb\u03b5\u03b9\u03b4\u03b9\u03ac \u03b3\u03c1\u03b1\u03c6\u03b5\u03af\u03bf\u03c5 \u2192<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0393\u03b9\u03b1 \u03bd\u03b1 \u03bc\u03b5\u03c4\u03c1\u03ae\u03c3\u03b5\u03c4\u03b5 \u03c4\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae\u03c2 \u03c3\u03c4\u03bf Excel, \u03ba\u03ac\u03b8\u03b5 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03c0\u03c1\u03ce\u03c4\u03b1 \u03bd\u03b1 \u03c3\u03c5\u03bd\u03b4\u03b5\u03b8\u03b5\u03af \u03bc\u03b5 \u03ad\u03bd\u03b1 \u03ba\u03b5\u03bb\u03af \u03c0\u03bf\u03c5 \u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 \u03c4\u03b7\u03bd \u03c4\u03b9\u03bc\u03ae TRUE \u03ae FALSE. \u03a3\u03c4\u03b7 \u03c3\u03c5\u03bd\u03ad\u03c7\u03b5\u03b9\u03b1, \u03ad\u03bd\u03b1\u03c2 \u03c4\u03cd\u03c0\u03bf\u03c2 COUNTIF \u03ba\u03b1\u03c4\u03b1\u03bc\u03b5\u03c4\u03c1\u03ac \u03b1\u03bc\u03ad\u03c3\u03c9\u03c2 \u03c4\u03b1 \u03b5\u03c0\u03b9\u03bb\u03b5\u03b3\u03bc\u03ad\u03bd\u03b1 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03b1. <\/p>\n","protected":false},"author":1483,"featured_media":38358,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_glsr_average":0,"_glsr_ranking":0,"_glsr_reviews":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[363,370],"tags":[],"class_list":["post-38354","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-363","category-370"],"acf":[],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/keyfy.com\/wp-content\/uploads\/2026\/08\/magnific_closeup-of-hands-using-a-_w4ZIUlZ7EI.webp","_links":{"self":[{"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/posts\/38354","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/users\/1483"}],"replies":[{"embeddable":true,"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/comments?post=38354"}],"version-history":[{"count":0,"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/posts\/38354\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/media\/38358"}],"wp:attachment":[{"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/media?parent=38354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/categories?post=38354"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/tags?post=38354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}