How to count (countifs) based on MORE THAN one in a single criteria excel

P

Plukey

Board Regular
Joined
Apr 19, 2019
Messages
138
Office Version
  1. 2016
Platform
  1. Windows
The below formula is in cell O4. Its a pivot table that the main slicer is connected too. The one slicer is connected to all of the Charts and tables. I was asked to place a birds eye count view on the dashboard. If you only select a single AOR it does what its supposed to do. Well...now they want it to also total when selecting more than one AOR at a time. If there's another way that's easier I'm open to suggestions.

Excel Formula: 
=COUNTIFS(Mondays_Report[PLN Complete],"no",Mondays_Report[AOR],M4,Mondays_Report[PLN-BD SchFin],"<"&TODAY())+COUNTIFS(Mondays_Report[PLN ActFin],"<>"&"",Mondays_Report[AOR],M4,Mondays_Report[PLN-BD SchFin],"<"&TODAY())

1655125179016.png
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Sort by date Sort by votes
I found a work around, I just copied the formulas down.... But, I still would like to know if there is a way to just use one formula.

1655134300601.png
 
Upvote 0
Solution
You must log in or register to reply here.

Similar threads

P
  • Solved
Countifs with multiple, multiple criteria
Replies
6
Views
253
smozgur
smozgur
O
  • Question
Count only one occurrence of all criteria being met
Replies
8
Views
443
KRice
K
J
  • Solved
Sumproduct with multiple countifs of a range within a range
2
Replies
13
Views
2K
J_W
J
B
  • Question
COUNTIFS that will ignore eligible criteria if the date has already been counted
Replies
2
Views
345
Fluff
Fluff
B
  • Question
Excel takes too long to open in Microsoft Teams
Replies
1
Views
663
mrshl9898
M

Forum statistics

Threads
1,215,054
Messages
6,122,893
Members
449,097
Latest member
dbomb1414

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top