asked on
Excel Formula NOT logic
I use the following =COUNTIFS(Raw_20180918!V:V
How do I determine how many entries are NOT approved?
How do I determine how many entries are NOT approved?
Microsoft ExcelMicrosoft Office
Last Comment
Matt Pinkston
ASKER
I am getting 1048576 like it is reading a ton a blank lines at the end?
ASKER
I am getting 1048576 like it is reading a ton a blank lines at the end?
Try:
=COUNTA(Raw_20180918!V:V)-
This counts all non-blank cells and deducts those with "Approved"
=COUNTA(Raw_20180918!V:V)-
This counts all non-blank cells and deducts those with "Approved"
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
The 2nd criteria in the formula I posted should exclude blank cells from the count
If it isn't then there might be a problem with the data, so it might be better to use the formula Rob suggested.
If it isn't then there might be a problem with the data, so it might be better to use the formula Rob suggested.
ASKER
thanks
Try this.
=COUNTIFS(Raw_20180918!V:V