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
Highlighted

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
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies