Sales qualified leads per month
Initial data
- the list of leads with different scoring for a particular month.
Task
- to count up how many leads with particular scoring are there.
=IMPORTRANGE("URL","January!A:A")
=COUNTIF(F:F,">=25")
COUNT cells that are not blank (and not count those ones that containes title)
=COUNTA(F:F")-1
=COUNTIF(IMPORTRANGE("url","Dec 2021!F:F"), ">=25")
=COUNTIF(IMPORTRANGE("url","Dec 2021!T:T"), "*referral*")
=countifs(F:F,">24",Q:Q,">0")
=arrayformula(CountIfs(ImportRange("url","February 2021!f:f"),">24",ImportRange("url","February 2021!o:o"),">0"))
=arrayformula(CountIfs(
ImportRange("url","February 2021!f:f"),">24",
ImportRange("url","February 2021!o:o"),">0",
ImportRange("url","February 2021!t:t"),"*referral*"))
COUNTIFS With OR For Multiple Criteria
=COUNTIF(
ImportRange("url","february 2020!t:t"),"*linkedin*")+COUNTIF(
ImportRange("url","february 2020!t:t"),"*referral*")
=UNIQUE(A2:A16) - copy and paste unique entries from the list with duplicate entries
=COUNTIF(A2:A16, C2) - count the number of unique queries
=QUERY(agregated!A:A,"select * where A contains 'sharepoint'",1)
=VLOOKUP(A386,KPnov01!$A$2:$J$856,2,false)
Explanation:
– search the value from A386 from the current tab (value=”php development company”)
– in the range A2:A856 of another tab (tabname=KPnov01),
– return a matching value of A386 from column B (2nd column in range) from KPnov01.
=IFERROR (VLOOKUP($A$2,$A$2:$B$10,2,0),"Not Found")
=CONCATENATE(A2,"/",B2)
Leave a Reply