Count Leads from Specific Source
I need to count how many leads in my monthly report came specifically from 'Organic Search'.
=COUNTIF(B2:B7,"Organic Search") How it works: The COUNTIF function counts the number of cells within a specified range that meet a given criterion. In this scenario, `B2:B7` is the range of cells containing lead sources, and `"Organic Search"` is the criterion. The function will scan each cell in the range and increment a counter every time it finds 'Organic Search', providing an accurate total for leads from that specific source.
Data Setup
| Lead ID | Lead Source |
|---|---|
| 101 | Organic Search |
| 102 | Paid Ad |
| 103 | Organic Search |
| 104 | Referral |
| 105 | Organic Search |
| 106 | Social Media |
Step-by-Step Guide
Open your monthly lead report in Excel.
Identify the column that contains the 'Lead Source' information (e.g., Column B).
Select an empty cell where you want the total count to appear (e.g., C1).
Type the formula: `=COUNTIF(B2:B7,"Organic Search")`
Press Enter to get the count of leads from 'Organic Search'.
Explore More
Create Comma-Separated Keyword Tags
I have a column of individual keywords and need to combine them into a single cell separated by commas for meta tags.
Extract File Extensions from URLs
I have a list of image URLs and need to extract the file type (e.g., .jpg, .png) from the end of the string. This is crucial for categorizing assets, checking file formats, or preparing data for content management systems.
Find Campaign ROI by ID (Return 0 if Missing)
I need to look up the ROI for a campaign ID, but if the ID isn't found, I want it to return '0' instead of an error.
Map Lead Source to CRM Code
I have a list of lead sources like 'Facebook' and need to find their corresponding numeric code from a reference table.