Home

Sumif formula need help

Highlighted
Sukhmani2485
Occasional Visitor

Hi, The below formula is what I am using to individually calculate the data based on the year and months selected from the dropdown. Please advise what should I add to get the overall sum if I select "All" in months and years in cell range C14 (Year All) and E14 (Months All)  

=COUNTIFS('Email Merge Data'!C:C,DashBoard!C17,'Email Merge Data'!M:M,DashBoard!$E$14,'Email Merge Data'!N:N,DashBoard!C14)

2 Replies

In general criteria to calculate all non-blank is "<>". Thus it could be like

=COUNTIFS(<range>,IF($C$17="All","<>",$C$17),<range2>,...)

How it'll be in your concrete case it's bit hard to say without knowing which data do you have in columns M and N, where are your C14 and C17, etc.

 

I've moved this to the Excel space for better visibility.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies