How to Exclude Values in COUNTIF | COUNTIFS NOT EQUAL to Multiple Text | Exclude Values from List

Download the featured file here: www.bluepecantraining.com/wp-...
In this video I demonstrate how to exclude values when performing a COUNTIF. Normally when you perform a COUNTIF you want to specify which values to count. What if you want to count everything but...
I show you how to exclude a single value or multiple values in your COUNTIF calculation.
The functions used in this video are COUNTIF, COUNTIFS, MATCH, ISNA, SUM and SUMPRODUCT.
------------------------

[@dorothymcclendon3753]

Thank you, it helped tremendously with a project and had to create at work.

[@mesfindaksa]

Thanks

[@IvanCortinas_ES]

Very fine Chester. Thank you for this great job!!

[@patrickschardt7724]

That ISNA/MARCH trick is very useful
Annoyingly COUNTIF/S can only handle direct cell references and not array results so they are somewhat limited.
Great tutorial as usual

[@chrisrooney2274]

Nice work Chester, this helped a lot!

[@annalink5186]

Thank you! It helped me to solve my issue!

[@tayboonpingkpm-guru6753]

Thank you, it is very helpful. 👍

[@Planetgreenzen]

This helped a lot, thank you

[@babajibait9704]

Thanks for your this video, you solved my one issue...great!!

[@Anikvikram]

Thanks Chester 😊, great help

[@ConnorMcLarnon]

Hi Chester, I am wondering if you can help me. I need to achieve what you did in second part of your video (exclude multiple referenced cells) but the issue is I have quite an extensive list of what I want to exclude. The issue is to write it using a countif would be quite long and I can't figure out how to use the match function in my formula as I need countifs to look for something specific in my data before I exclude. I hope I have been clear and thanks in advance for any clarification.

[@amam7748]

This is so helpful. Thank you! One more question, can I exclude the blank cell in this formula (countifs not equal) too?

[@Breewilly]

Whew! Had to do this for a report at Job! Thank you so much!

[@ChesterTugwell]

Glad it helped!

[@uzmi-Creations]

Good information

[@arghyadutta9091]

Great

[@famgee]

I have a question for you if you can help. I have a table that I want to get the percentage of each column and within some columns exist merged cells. How can I draft a formula to count blanks and not merged cells of the same column? For instance P10 to P15, with 11, 12, inside a merged cell. The first column works with a countblank and sum divided by the number of rows, but the second column counts all cells as 100% instead of just the blank cells and not the merged cells as empty when they are apart of the merged cells.

[@pinkishcheeks]

Is there a way to exclude the checkboxes in hidden columns? Say, if we're trying to get an average percentage of completion in a set of data, but a particular column's data is no longer relevant, can we simply hide it and automatically have THAT data not counted anymore?

[@jmullen99]

Hi, I am struggling. I was able to follow your steps and make my list to exclude the criteria I wanted excluded, but it is now counting blank cells and I can't figure out how to exclude the 3 blank cells as well

[@user-jv6kk9td9m]

what if you had a string of text in the same cell (Apples, strawberries, Pears) and you wanted to get a count, but only if the cell wasn't blank OR had "N/A" in the box?

[@n.h.3503]

I need help. I’m doing an evaluation table . If criteria valid cell is marked V, if not X. How do you identify the error rate with just zero or 1. As long as only 1 X in range, the error will be 1 max.

[@Atlexplore]

Mine keeps including the value I'm trying to exclude. Is there something I'm missing?

[@vinujose]

I need some formula same as countifs(multiple criteria) but the duplicate count only once.

[@fredatang4058]

What if we want to exclude more than one criteria? thanks

[@fredatang4058]

I mean instead of add the criteria one by one, is there a way to do it in at once, for example, "" & "Apple"&"Kiwi", something like that. Thanks