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.

 

Highlighted
I've moved this to the Excel space for better visibility.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies