Community Hubs Home
Products
Special Topics
Video Hub

Most Active Hubs

Microsoft Teams

Security, Compliance and Identity

Intune and Configuration Manager

Microsoft Edge Insider

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

AI and Machine Learning

Microsoft Mechanics

Microsoft Partner Community

Healthcare and Life Sciences

Internet of Things (IoT)

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

Microsoft 365 Business

Microsoft 365 Enterprise

Microsoft Outlook

Microsoft Teams

Browse All Community Hubs

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

1.2M Members
7,304 Online
310K 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

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
Microsoft 365
Microsoft 365
stuck with.. countifs or sumproduct

stuck with.. countifs or sumproduct

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

BerlyLinkin

Copper Contributor

‎Oct 15 2023 07:59 PM

Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Report Inappropriate Content

‎Oct 15 2023 07:59 PM

stuck with.. countifs or sumproduct

Hi!

I was just practising but I think I got stuck .. tried using the countifs but not able to solution for the year criterias

Labels:

Labels:
Account Management
Excel
Microsoft 365
Microsoft Learn
Office 365

Preview file

1668 KB



84 Views

Reply

All Discussions
Previous Discussion
Next Discussion

0 Replies

Share

Share to LinkedIn
Share to Facebook
Share to Twitter
Share to Reddit
Share to Email

What's new

Surface Pro 9
Surface Laptop 5
Surface Studio 2+
Surface Laptop Go 2
Surface Laptop Studio
Surface Duo 2
Microsoft 365
Windows 11 apps

Microsoft Store

Account profile
Download Center
Microsoft Store support
Returns
Order tracking
Virtual workshops and training
Microsoft Store Promise
Flexible Payments

Education

Microsoft in education
Devices for education
Microsoft Teams for Education
Microsoft 365 Education
Education consultation appointment
Educator training and development
Deals for students and parents
Azure for students

Business

Microsoft Cloud
Microsoft Security
Dynamics 365
Microsoft 365
Microsoft Power Platform
Microsoft Teams
Microsoft Industry
Small Business

Developer & IT

Azure
Developer Center
Documentation
Microsoft Learn
Microsoft Tech Community
Azure Marketplace
AppSource
Visual Studio

Company

Careers
About Microsoft
Company news
Privacy at Microsoft
Investors
Diversity and inclusion
Accessibility
Sustainability

Sitemap
Contact Microsoft
Privacy
Manage cookies
Terms of use
Trademarks
Safety & eco
About our ads
© Microsoft 2023