Google Sheets - COUNTUNIQUEIFS given-date-x is 30 days ...

COUNTUNIQUEIFS(). formula and am stuck on (Status Quo). (Goal) will tell me true sales efficiency. All onboarded customers are given a month ... Skiptocontent GoogleSheets–COUNTUNIQUEIFSgiven-date-xis30daysawayfromgiven-date-y 15viewsJune17,2021excelexcelgoogle-sheetsgoogle-sheets-formula Attribution:https://stackoverflow.com/q/68026555 0 Saswata383.07K June17,2021 0Comments Defn CohortedConversionRate(Goal):%ofcustomerswhoboughtaproductwithin30daysofonboardingdate CohortedConversionRate(StatusQuo):%ofcustomerswhoboughtaproductwithinonboardingmonth Problem Iamtryingtocalculate(Goal)rateusingthe COUNTUNIQUEIFS()formulaandamstuckon(StatusQuo). (Goal)willtellmetruesalesefficiency.Allonboardedcustomersaregivenamonth(amonthbeingheldconstantat30daystoconvert. (StatusQuo)isafalselookatsalesefficiency.Customerswhoareonboardedatthebeginningofthemontharegivenamonthtoconvert;however,customerswhoareonboardedattheendofthemontharegivendaystoconvert.(StatusQuo)iscalculatedlikethis: =COUNTUNIQUEIFS(Master!B:B,Master!AA:AA,">="&2,Master$AA:$AA,"<="&2,Master$A:$A,C18)(seeattachedsheetforadditionalcontext). SampleData https://docs.google.com/spreadsheets/d/1mDr1yApBiestKx1UqcK5zFNEzvNlu7NOIVeFllykBaI/edit?usp=sharing Ask Couldyoupleasehelpmegetfrom(StatusQuo)to(Goal)? 0 Answers ActiveVotedNewestOldest Register or Login Follow: Nextstory CanatablestatuschangetriggeraneventinOracleNoSQLDatabaseCloudService? Previousstory Howtouse‘XRSimpleInteraction’ManagerInUnity Searchfor: Tags3rdwaveIndia beautifulplaces calciumcarbonate chile cliff codeforces covid19 cp DATE difficulty2000 Education express FakeUniversity fullstack html India javascript JEE JEEMAIN lake marblecave NEET NEET-UG nextcovidwaves node.js numbertheory prehistoric python-bengali saltflat saltlake socket.io tourist touristplace travel UGC US whiteboard wonders পাইথন +ads CategoriesCategories SelectCategory CompetitiveProgramming Education    Engineering       computerscience    Medical health places programminglanguages    python–inbengali Sciene    chemistry    physics software    development    Fullstack technology    gadgets travel Uncategorized বাংলা RecentCommentsdownloadonপাইথনেরভূমিকাdownloadonMarbleCaves,PatagoniayifyonMarbleCaves,PatagoniabedavaonMarbleCaves,PatagoniayifyonMarbleCaves,Patagonia+ads Archives Archives SelectMonth November2021 October2021 April2021 December2020 November2020 October2020 September2020 August2020 August2019 July2019 June2019 +ads More RecentPosts findtwodivisorsofanumber,suchthatthegcdofthesumofthosedivisorsandthenumberequals1 Createdanonlinewhiteboardwithin30minutes!HOW? HowdoIconsiderasmartphoneworthbuying? ASmallestimationfornext4monthscovidwavesindifferentpartsoftheworld Codechef|April21challenge|WorthyMatrix|solution|KAVGMAT RecentCommentsdownloadonপাইথনেরভূমিকাdownloadonMarbleCaves,PatagoniayifyonMarbleCaves,PatagoniabedavaonMarbleCaves,PatagoniayifyonMarbleCaves,PatagoniaSupportUs BTCaddresslink Weusecookiesonourwebsitetogiveyouthemostrelevantexperiencebyrememberingyourpreferencesandrepeatvisits.Byclicking“Accept”,youconsenttotheuseofALLthecookies.Donotsellmypersonalinformation.CookieSettingsAcceptManageconsent Close PrivacyOverview Thiswebsiteusescookiestoimproveyourexperiencewhileyounavigatethroughthewebsite.Outofthese,thecookiesthatarecategorizedasnecessaryarestoredonyourbrowserastheyareessentialfortheworkingofbasicfunctionalitiesofthewebsite.Wealsousethird-partycookiesthathelpusanalyzeandunderstandhowyouusethiswebsite.Thesecookieswillbestoredinyourbrowseronlywithyourconsent.Youalsohavetheoptiontoopt-outofthesecookies.Butoptingoutofsomeofthesecookiesmayaffectyourbrowsingexperience. Necessary Necessary AlwaysEnabled Necessarycookiesareabsolutelyessentialforthewebsitetofunctionproperly.Thesecookiesensurebasicfunctionalitiesandsecurityfeaturesofthewebsite,anonymously. CookieDurationDescriptioncookielawinfo-checkbox-analytics11monthsThiscookieissetbyGDPRCookieConsentplugin.Thecookieisusedtostoretheuserconsentforthecookiesinthecategory"Analytics".cookielawinfo-checkbox-functional11monthsThecookieissetbyGDPRcookieconsenttorecordtheuserconsentforthecookiesinthecategory"Functional".cookielawinfo-checkbox-necessary11monthsThiscookieissetbyGDPRCookieConsentplugin.Thecookiesisusedtostoretheuserconsentforthecookiesinthecategory"Necessary".cookielawinfo-checkbox-others11monthsThiscookieissetbyGDPRCookieConsentplugin.Thecookieisusedtostoretheuserconsentforthecookiesinthecategory"Other.cookielawinfo-checkbox-performance11monthsThiscookieissetbyGDPRCookieConsentplugin.Thecookieisusedtostoretheuserconsentforthecookiesinthecategory"Performance".viewed_cookie_policy11monthsThecookieissetbytheGDPRCookieConsentpluginandisusedtostorewhetherornotuserhasconsentedtotheuseofcookies.Itdoesnotstoreanypersonaldata. Functional Functional Functionalcookieshelptoperformcertainfunctionalitieslikesharingthecontentofthewebsiteonsocialmediaplatforms,collectfeedbacks,andotherthird-partyfeatures. Performance Performance Performancecookiesareusedtounderstandandanalyzethekeyperformanceindexesofthewebsitewhichhelpsindeliveringabetteruserexperienceforthevisitors. Analytics Analytics Analyticalcookiesareusedtounderstandhowvisitorsinteractwiththewebsite.Thesecookieshelpprovideinformationonmetricsthenumberofvisitors,bouncerate,trafficsource,etc. Advertisement Advertisement Advertisementcookiesareusedtoprovidevisitorswithrelevantadsandmarketingcampaigns.Thesecookiestrackvisitorsacrosswebsitesandcollectinformationtoprovidecustomizedads. Others Others Otheruncategorizedcookiesarethosethatarebeinganalyzedandhavenotbeenclassifiedintoacategoryasyet. SAVE&ACCEPT