Home

Sumif formula need help

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
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies