Microsoft
Tech Community
Home
Community Hubs
Community Hubs
Community Hubs Home
Products
Special Topics
Video Hub
Close
Products
(50)
Special Topics
(27)
Video Hub
(460)
Most Active Hubs
Microsoft 365
Microsoft Teams
Windows
Outlook
Security, Compliance and Identity
SharePoint
Azure
Windows Server
Exchange
Intune and Configuration Manager
Microsoft Edge Insider
OneDrive
Microsoft Viva
Connect and learn from experts and peers
Microsoft FastTrack
Best practices and the latest news on Microsoft FastTrack
Microsoft Sales Copilot
A role-based copilot designed for sellers
Most Active Hubs
Education Sector
ITOps Talk
AI and Machine Learning
Microsoft Mechanics
Microsoft Partner Community
Healthcare and Life Sciences
Internet of Things (IoT)
Public Sector
Mixed Reality
Small and Medium Business
Startups at Microsoft
Azure Partner Community
Expand your Azure partner-to-partner network
Microsoft Tech Talks
Bringing IT Pros together through In-Person & Virtual events
MVP Award Program
Find out more about the Microsoft MVP Award Program.
Video Hub
Azure
Exchange
Microsoft 365
Microsoft 365 Business
Microsoft 365 Enterprise
Microsoft Edge
Microsoft Outlook
Microsoft Teams
Security
SharePoint
Windows
Blogs
Blogs
Events
Events
Events Home
Microsoft Ignite
Microsoft Build
Community Events
Microsoft Learn
Microsoft Learn
Home
Community
Blog
Azure
Dynamics 365
Microsoft 365
Security, Compliance & Identity
Power Platform
Github
Teams
.NET
Lounge
Lounge
1.3M
Members
5,689
Online
325K
Discussions
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Show
only
|
Search instead for
Did you mean:
Sign In
Sign In
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Show
only
|
Search instead for
Did you mean:
Home
Home
Microsoft 365
Excel
Countif
Countif
Discussion Options
Subscribe to RSS Feed
Mark Discussion as New
Mark Discussion as Read
Pin this Discussion for Current User
Bookmark
Subscribe
Printer Friendly Page
Excel115
Copper Contributor
Sep 11 2019
10:22 AM
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Report Inappropriate Content
Sep 11 2019
10:22 AM
Countif
Is there a way of counting a specific word in a column but not count the word if it's in a coloured cell?
Labels:
Labels:
Formulas and Functions
All Discussions
Previous Discussion
Next Discussion
1 Reply
erol sinan zorlu
replied to
Excel115
Sep 11 2019
11:25 AM
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Report Inappropriate Content
Sep 11 2019
11:25 AM
RE: Countif
if color is given by conditional formatting you can use the same condition in COUNTIFS formula. otherwise there is no formula to get cell color. the only way is to create a table with filter and try to count with aggregate
Browse