5:["$","$L16",null,{"demo":{"id":"T-tSgwSHkDn40CPZCma3f","createdAt":"2024-02-26T13:59:18.368Z","updatedAt":"2024-08-19T10:53:52.170Z","title":"How to use \"countif\" in Google Sheets","published":true,"color":"bg-gray-200","authorId":"clpuqml380gpfpen01p6lxgt6","metadesc":"Click through a step-by-step, interactive demo walkthrough of Google, powered by Supademo.","ctabtntext":"Create Supademo","ctabtncolor":"#0051c9","ctabtntextcolor":"#fff","ctabtnlink":"https://app.supademo.com/signup?utm_source=supademo&utm_medium=supademo&utm_campaign=supademo_cta","autoplay":false,"autoplayduration":3000,"autoPlayDelay":0,"showplaypause":true,"loop":false,"progressbar":false,"font":"Default","workspaceId":"muX33bJGOFbXOjmJWCKXF","darkmode":true,"shared":true,"folderId":"clsvyst3i14i9pekcjruwrpih","border":true,"nextButton":true,"showSteps":false,"globalSettings":true,"hotspotTextVisible":true,"hotspotOpacity":"70","number":null,"topBar":true,"indexable":true,"displayAuthor":true,"displayDescription":true,"showSupademoLink":true,"showCCButton":true,"archived":false,"archivedAt":null,"domainURL":null,"brandLogo":"https://d2vsad3r6ug0tf.cloudfront.net/workspacelogos/URNATSDtAePdH3Xmdpf8i","allowDuplicate":false,"recordOwnVoice":false,"backgroundId":"cm00vff2a00eh15grpk5y56xt","backgroundMusicUrl":null,"backgroundMusicVolume":50,"demoSource":null,"type":"Default","fullWidth":false,"detectBrowserLanguage":true,"customFontId":null,"mobileHotspotView":true,"author":{"id":"clpuqml380gpfpen01p6lxgt6","name":"Nithileashwar Shanmugam","image":"https://lh3.googleusercontent.com/a/ACg8ocIxG5rOtoDRQoypVxDJcKmabhZO6nJWJfvd5KFB3rFp=s96-c"},"steps":[{"id":"F3-I7vTMd2usaSAetPFtn","number":"1","text":"Chapter","image":null,"video":null,"createdAt":"2024-08-19T10:46:22.830Z","updatedAt":"2024-08-19T10:46:22.830Z","demoId":"T-tSgwSHkDn40CPZCma3f","imageWidth":"688","imageHeight":"0","mouseXCooridnate":"0","mouseYCooridnate":"0","editedImage":null,"widthOrg":601,"heightOrg":303,"bgcolor":"#4f46e5","textcolor":"#fff","imgState":null,"trimStart":"0","trimEnd":"100","videoWidth":null,"videoHeight":null,"videoDuration":null,"audio":null,"audioText":null,"voice":null,"audioLanguage":null,"audioDuration":null,"captionsUrl":null,"zoomPositionX":null,"zoomPositionY":null,"zoomWidth":null,"zoomHeight":null,"playbackRate":"1","mediaFitMode":"Cover","mediaAlignMode":"Top","htmlCaptureId":null,"backdrop":"None","pageUrl":null,"recordingSessionId":null,"preventScroll":false,"hotspots":[],"chapter":{"id":"71eR3nlJ9rMYcfuqL3tjk","stepId":"F3-I7vTMd2usaSAetPFtn","enabled":true,"type":"Link","skip":false,"heading":"How to use \"countif\" in Google Sheets","description":"Click below for a step-by-step walkthrough","headingColor":"#272727","descriptionColor":"#272727","theme":"Light","blurIntensity":24,"allowCompanyEmail":true,"embedCode":null,"buttons":[{"id":"uJiVatatQRt_9ExnnAoOm","createdAt":"2024-08-19T10:46:22.985Z","updatedAt":"2024-08-19T10:46:36.185Z","chapterId":"71eR3nlJ9rMYcfuqL3tjk","content":"Get Started","btnColor":"#00d084","color":"#fff","linkTxt":"clt3096rp5h3qped7rggpj72g","isLinkExternal":false,"openInNewTab":true,"animation":"Ripple","order":0}],"backgroundId":null,"background":null,"formFields":[]},"comments":[]},{"id":"clt3096rp5h3qped7rggpj72g","number":"2","text":"Click on \" \"","image":"https://d2vsad3r6ug0tf.cloudfront.net/clpuqml380gpfpen01p6lxgt6/4VTU9emRxfVh7FUxjX.png","video":null,"createdAt":"2024-02-26T13:59:20.965Z","updatedAt":"2024-08-19T10:52:07.696Z","demoId":"T-tSgwSHkDn40CPZCma3f","imageWidth":"688","imageHeight":"348","mouseXCooridnate":"6.25","mouseYCooridnate":"77.9639175257732","editedImage":null,"widthOrg":1920,"heightOrg":970,"bgcolor":"#4f46e5","textcolor":"#fff","imgState":null,"trimStart":"0","trimEnd":"100","videoWidth":null,"videoHeight":null,"videoDuration":null,"audio":"https://media.supademo.com/clyszkgee00ww8ku0ja57y4wk/audio/SPghyPn1mkvh4a1AavFYh.mp3","audioText":"Click the designated box to initiate results.","voice":"FPQ1Odtu8U6Edy2qyGcI","audioLanguage":null,"audioDuration":"2.533877551020408","captionsUrl":null,"zoomPositionX":null,"zoomPositionY":null,"zoomWidth":null,"zoomHeight":null,"playbackRate":"1","mediaFitMode":"Cover","mediaAlignMode":"Center","htmlCaptureId":null,"backdrop":"None","pageUrl":null,"recordingSessionId":null,"preventScroll":false,"hotspots":[{"id":"clt3096sn5h3rped7bj9r4thf","number":"2","createdAt":"2024-02-26T13:59:21.000Z","updatedAt":"2024-08-19T10:49:48.545Z","default":false,"text":"Click on the box to get the result.","bgcolor":"#00d084","textcolor":"#fff","mouseXCooridnate":"6.25","mouseYCooridnate":"77.9639175257732","style":"Circle","animation":"Ping","isVisible":true,"boxWidth":null,"boxHeight":null,"prevslide":null,"nextslide":"clt309fot0cvrbpprd706ec50","stepId":"clt3096rp5h3qped7rggpj72g","tipposition":"right","nextButton":true,"textVisible":null,"htmlValue":"

","aiText":"Click the designated box to initiate results.","aiTextVisible":true,"anchorNodeId":null,"nextButtonText":null,"backButtonText":null,"hotspotWidth":"Medium"}],"chapter":null,"comments":[]},{"id":"clt309gqq5h48ped7rcdm9t4z","number":"3","text":"Click on \"countif\"","image":"https://d2vsad3r6ug0tf.cloudfront.net/clpuqml380gpfpen01p6lxgt6/6w-9_zKP7YRsZt4IAJ.png","video":null,"createdAt":"2024-02-26T13:59:33.891Z","updatedAt":"2024-08-19T10:52:22.166Z","demoId":"T-tSgwSHkDn40CPZCma3f","imageWidth":"688","imageHeight":"348","mouseXCooridnate":"6.575520833333333","mouseYCooridnate":"78.22164948453609","editedImage":null,"widthOrg":1920,"heightOrg":970,"bgcolor":"#4f46e5","textcolor":"#fff","imgState":null,"trimStart":"0","trimEnd":"100","videoWidth":null,"videoHeight":null,"videoDuration":null,"audio":"https://media.supademo.com/clyszkgee00ww8ku0ja57y4wk/audio/E4aLqaJAE5cELGU5Ijkbs.mp3","audioText":"Next, enter the 'countif' formula into the spreadsheet.","voice":"FPQ1Odtu8U6Edy2qyGcI","audioLanguage":null,"audioDuration":"3.056326530612245","captionsUrl":null,"zoomPositionX":"0","zoomPositionY":"30","zoomWidth":"70","zoomHeight":"70","playbackRate":"1","mediaFitMode":"Cover","mediaAlignMode":"Center","htmlCaptureId":null,"backdrop":"None","pageUrl":null,"recordingSessionId":null,"preventScroll":false,"hotspots":[{"id":"clt309grg5h49ped7qxrww5ie","number":"6","createdAt":"2024-02-26T13:59:33.917Z","updatedAt":"2024-08-19T10:49:55.944Z","default":false,"text":"Following that, enter =countif(A2:A7,\"are\")","bgcolor":"#00d084","textcolor":"#fff","mouseXCooridnate":"8.413704762504853","mouseYCooridnate":"78.4035593965823","style":"Area","animation":"Pulse","isVisible":true,"boxWidth":"11.62649111048876","boxHeight":"10.64250190917098","prevslide":null,"nextslide":"clt309hs35h4fped734mqtnvx","stepId":"clt309gqq5h48ped7rcdm9t4z","tipposition":"right","nextButton":true,"textVisible":null,"htmlValue":"countif","aiText":"Next, enter the 'countif' formula into the spreadsheet.","aiTextVisible":true,"anchorNodeId":null,"nextButtonText":null,"backButtonText":null,"hotspotWidth":"Medium"}],"chapter":null,"comments":[]},{"id":"clt309hs35h4fped734mqtnvx","number":"4","text":"Click on \"\"Joe\"\"","image":"https://d2vsad3r6ug0tf.cloudfront.net/clpuqml380gpfpen01p6lxgt6/pKdPyWBG6o9HJ7SabJ.png","video":null,"createdAt":"2024-02-26T13:59:35.235Z","updatedAt":"2024-08-19T10:52:32.686Z","demoId":"T-tSgwSHkDn40CPZCma3f","imageWidth":"688","imageHeight":"348","mouseXCooridnate":"10.9375","mouseYCooridnate":"77.44845360824742","editedImage":null,"widthOrg":1920,"heightOrg":970,"bgcolor":"#4f46e5","textcolor":"#fff","imgState":null,"trimStart":"0","trimEnd":"100","videoWidth":null,"videoHeight":null,"videoDuration":null,"audio":"https://media.supademo.com/clyszkgee00ww8ku0ja57y4wk/audio/G_QPIrse3pDxRSb1o61dt.mp3","audioText":"Now, customize the formula according to your specific needs.\n\\=COUNTIF(RANGE,CRITERIA)","voice":"FPQ1Odtu8U6Edy2qyGcI","audioLanguage":null,"audioDuration":"6.086530612244898","captionsUrl":null,"zoomPositionX":"0","zoomPositionY":"30","zoomWidth":"70","zoomHeight":"70","playbackRate":"1","mediaFitMode":"Cover","mediaAlignMode":"Center","htmlCaptureId":null,"backdrop":"None","pageUrl":null,"recordingSessionId":null,"preventScroll":false,"hotspots":[{"id":"clt309hss5h4gped7ehmr920z","number":"7","createdAt":"2024-02-26T13:59:35.261Z","updatedAt":"2024-08-19T10:50:05.183Z","default":false,"text":"Adjust according to =COUNTIF(RANGE,CRITERIA)","bgcolor":"#00d084","textcolor":"#fff","mouseXCooridnate":"9.283134025489058","mouseYCooridnate":"77.99422671823255","style":"Area","animation":"Pulse","isVisible":true,"boxWidth":"12.54557650122592","boxHeight":"12.09788530277227","prevslide":null,"nextslide":"clt309ps00cvvbpprkntr5dsl","stepId":"clt309hs35h4fped734mqtnvx","tipposition":"right","nextButton":true,"textVisible":null,"htmlValue":"\"Joe\"","aiText":"Now, customize the formula according to your specific needs.\n\\=COUNTIF(RANGE,CRITERIA)","aiTextVisible":true,"anchorNodeId":null,"nextButtonText":null,"backButtonText":null,"hotspotWidth":"Medium"}],"chapter":null,"comments":[]},{"id":"clt309ps00cvvbpprkntr5dsl","number":"5","text":"No content","image":null,"video":"https://media.supademo.com/clpuqml380gpfpen01p6lxgt6/videos/_p1h0ONDO5iGki79z1CPN.mp4","createdAt":"2024-02-26T13:59:45.600Z","updatedAt":"2024-08-19T10:53:47.701Z","demoId":"T-tSgwSHkDn40CPZCma3f","imageWidth":"688","imageHeight":"0","mouseXCooridnate":"0","mouseYCooridnate":"0","editedImage":null,"widthOrg":1920,"heightOrg":970,"bgcolor":"#4f46e5","textcolor":"#fff","imgState":null,"trimStart":"0","trimEnd":"80.94053577532286","videoWidth":1920,"videoHeight":1078,"videoDuration":"6.066","audio":"https://media.supademo.com/clyszkgee00ww8ku0ja57y4wk/audio/vRBBBKPZ1NBfF_GWoE17P.mp3","audioText":"Enter the formula.","voice":"FPQ1Odtu8U6Edy2qyGcI","audioLanguage":null,"audioDuration":"1.436734693877551","captionsUrl":null,"zoomPositionX":"0","zoomPositionY":"30","zoomWidth":"70","zoomHeight":"70","playbackRate":"3","mediaFitMode":"Cover","mediaAlignMode":"Center","htmlCaptureId":null,"backdrop":"None","pageUrl":null,"recordingSessionId":null,"preventScroll":false,"hotspots":[],"chapter":null,"comments":[]},{"id":"clt309pi85h4oped7fx9ag5b2","number":"6","text":"Click on \" \"","image":"https://d2vsad3r6ug0tf.cloudfront.net/clpuqml380gpfpen01p6lxgt6/UDYZuNi_yAJzZEh78c.png","video":null,"createdAt":"2024-02-26T13:59:45.248Z","updatedAt":"2024-08-19T10:52:46.577Z","demoId":"T-tSgwSHkDn40CPZCma3f","imageWidth":"688","imageHeight":"348","mouseXCooridnate":"8.854166666666668","mouseYCooridnate":"78.35051546391753","editedImage":null,"widthOrg":1920,"heightOrg":970,"bgcolor":"#4f46e5","textcolor":"#fff","imgState":null,"trimStart":"0","trimEnd":"100","videoWidth":null,"videoHeight":null,"videoDuration":null,"audio":"https://media.supademo.com/clyszkgee00ww8ku0ja57y4wk/audio/l5cY5Z5PSnP7pJssptu3b.mp3","audioText":"Finally, click the box again to retrieve the frequency of the word.","voice":"FPQ1Odtu8U6Edy2qyGcI","audioLanguage":null,"audioDuration":"3.709387755102041","captionsUrl":null,"zoomPositionX":"0","zoomPositionY":"30","zoomWidth":"70","zoomHeight":"70","playbackRate":"1","mediaFitMode":"Cover","mediaAlignMode":"Center","htmlCaptureId":null,"backdrop":"None","pageUrl":null,"recordingSessionId":null,"preventScroll":false,"hotspots":[{"id":"clt309piz5h4pped73weplqdw","number":"9","createdAt":"2024-02-26T13:59:45.276Z","updatedAt":"2024-08-19T10:50:38.392Z","default":false,"text":"We got the result on number of times the word occured","bgcolor":"#00d084","textcolor":"#fff","mouseXCooridnate":"8.854166666666668","mouseYCooridnate":"78.35051546391753","style":"Circle","animation":"Ping","isVisible":true,"boxWidth":null,"boxHeight":null,"prevslide":null,"nextslide":"clt309q665h4tped7fw2rjh7l","stepId":"clt309pi85h4oped7fx9ag5b2","tipposition":"right","nextButton":true,"textVisible":null,"htmlValue":"

","aiText":"Finally, click the box again to retrieve the frequency of the word.","aiTextVisible":true,"anchorNodeId":null,"nextButtonText":null,"backButtonText":null,"hotspotWidth":"Medium"}],"chapter":null,"comments":[]},{"id":"clt309q665h4tped7fw2rjh7l","number":"7","text":"Chapter","image":null,"video":null,"createdAt":"2024-02-26T13:59:46.110Z","updatedAt":"2024-08-19T10:46:22.831Z","demoId":"T-tSgwSHkDn40CPZCma3f","imageWidth":"688","imageHeight":"0","mouseXCooridnate":"0","mouseYCooridnate":"0","editedImage":null,"widthOrg":1920,"heightOrg":970,"bgcolor":"#4f46e5","textcolor":"#fff","imgState":null,"trimStart":"0","trimEnd":"100","videoWidth":null,"videoHeight":null,"videoDuration":null,"audio":null,"audioText":null,"voice":null,"audioLanguage":null,"audioDuration":null,"captionsUrl":null,"zoomPositionX":null,"zoomPositionY":null,"zoomWidth":null,"zoomHeight":null,"playbackRate":"1","mediaFitMode":"Cover","mediaAlignMode":"Center","htmlCaptureId":null,"backdrop":"None","pageUrl":null,"recordingSessionId":null,"preventScroll":false,"hotspots":[],"chapter":{"id":"clt309q7r5h4vped7efanoc80","stepId":"clt309q665h4tped7fw2rjh7l","enabled":true,"type":"Link","skip":false,"heading":"Create a Supademo in seconds","description":"Scale up product adoption with beautiful AI-powered interactive demos.","headingColor":"#272727","descriptionColor":"#272727","theme":"Light","blurIntensity":24,"allowCompanyEmail":true,"embedCode":null,"buttons":[{"id":"clt309q965h4xped7lmi9mzww","createdAt":"2024-02-26T13:59:46.218Z","updatedAt":"2024-04-07T01:25:03.321Z","chapterId":"clt309q7r5h4vped7efanoc80","content":"Create a Supademo","btnColor":"#00d084","color":"#fff","linkTxt":"https://app.supademo.com/signup?utm_source=supademo&utm_medium=supademo&utm_campaign=supademo_cta","isLinkExternal":true,"openInNewTab":true,"animation":"Ripple","order":0}],"backgroundId":null,"background":null,"formFields":[]},"comments":[]}],"htmlEdits":[],"workspace":{"id":"muX33bJGOFbXOjmJWCKXF","createdAt":"2023-12-18T18:04:52.018Z","updatedAt":"2025-06-03T14:25:17.259Z","name":"Supa Marketing","color":"#054ab3","hotspottextcolor":"#fff","logo":"https://d2vsad3r6ug0tf.cloudfront.net/workspacelogos/URNATSDtAePdH3Xmdpf8i","favicon":null,"owner":"cl9yhqkao001bw60hq3exfo04","madein":true,"watermarkLogoUrl":"https://media.supademo.com/workspaces/muX33bJGOFbXOjmJWCKXF/teZ_xyWytKbCVOj7NL59Y.png","watermarkText":"Try Supademo","watermarkLink":"https://supademo.com","sharepagebtntext":"Create Better Demos in Minutes","sharepagebtncolor":"#0051c9","sharepagebtntextcolor":"#fff","sharepagebtnlink":"https://app.supademo.com/signup?utm_source=supademo&utm_medium=supademo&utm_campaign=supademo_cta","subscriptionId":"sub_1PdZyMDNBXQNFoJIUgEx59xA","autoplay":false,"autoplayduration":3000,"loop":false,"progressbar":false,"nextButton":true,"subDomain":"doccs.supademo.com","seoIndexable":true,"seoAuthor":false,"seoDescription":false,"showSteps":false,"font":"Default","showSupademoLink":true,"hotspotNextBtn":true,"hotspotTextVisible":true,"hotspotOpacity":"70","enableCreatorsToInvite":true,"stripeId":"cus_MmacA1X1MVv641","topBar":true,"darkmode":true,"plan":"Enterprise","tourSetup":false,"inTrial":false,"customDomainEnabled":false,"trackingEnabled":true,"autoJoinTeam":true,"linkViewNotifications":false,"monthlyStatsEmail":false,"invoiceEmail":false,"customDomainLandingPage":"https://app.supademo.com","isDiscounted":false,"enterpriseId":"cm0e1678d00004uaa10qwl59b","selectedCustomFontId":null,"backgroundMusicUrl":null,"hotspotNextBtnText":"Next","hotspotBackBtnText":"Back","integrations":[],"chapter":{"id":"cly2dm2yr11vdyerrvdongjm1","createdAt":"2024-07-01T02:44:03.075Z","updatedAt":"2024-07-01T02:44:03.075Z","stepId":null,"workspaceId":"muX33bJGOFbXOjmJWCKXF","enabled":true,"type":"Link","password":null,"skip":false,"heading":"Create a Supademo in seconds","description":"Scale up product adoption with beautiful AI-powered interactive demos.","theme":"Light","allowCompanyEmail":true,"embedCode":null,"blurIntensity":24,"headingColor":"#272727","descriptionColor":"#272727","backgroundId":null,"buttons":[{"id":"cly2dm37u11vfyerrs7l06rbd","createdAt":"2024-07-01T02:44:03.403Z","updatedAt":"2024-07-01T02:44:03.403Z","chapterId":"cly2dm2yr11vdyerrvdongjm1","content":"Create a Supademo","btnColor":"#054ab3","color":"#fff","linkTxt":"https://app.supademo.com/signup?utm_source=supademo&utm_medium=supademo&utm_campaign=supademo_cta","isLinkExternal":true,"openInNewTab":true,"animation":null,"order":0}],"background":null}},"background":{"id":"cm00vff2a00eh15grpk5y56xt","createdAt":"2024-08-19T10:46:37.570Z","updatedAt":"2024-08-19T10:46:37.570Z","type":"Color","value":"#A1E8BB","workspaceId":"muX33bJGOFbXOjmJWCKXF","demoId":"T-tSgwSHkDn40CPZCma3f","chapterId":null,"screenshotId":null},"translatedTexts":[],"translations":[],"customFont":null},"variablesFromUrl":[]}]