Excel formula: countifs and criteria "not blank" Solved

Question

Hello,

I am using Excel 2007, and I have been looking for some time to introduce a criterion in my COUNTIFS formula to eliminate empty cells. I tried <>"", but it shows me an error.
I know that the quotes in some formulas are reversed, but "<>""" or "<>"" " does not work either. If I just leave "<>", I do not get the correct results.
If someone can help me define this criterion, it would help me a lot.

Thank you in advance.

Vaucluse · Accepted Answer

Hello in principle: if the result of the formulas is not numeric and only in this case: COUNTIF(range,"") counts all cells that have a formula, even if they return "" COUNTIF(range,"") counts only the cells with a formula that return a text value  If the result of the formulas is numeric it is better to use a result like "0" instead of 0 and in this case  COUNTIF(range,"") counts only the "0" values and the texts

Bruce Willix · Answer

The quotation marks are inverted in some formulas? I was unaware... Which ones are affected?  Otherwise, try using the criterion NOT(ISBLANK()) - or rather ISBLANK() in the case that concerns you.  What is your complete formula? How is your data structured?  Remember remember the fifth of November Gunpowder, treason and plot. I see no reason why gunpowder, treason Should ever be forgot...

lelion4 · Answer

My file is structured in columns, and I use my COUNTIFS to make an initial distinction based on the type of objects (in rows).
For example, for the object "ream of paper" (sub-category = A4 format, A3, etc.), the first criterion will be the name of the object, which will sort and select the relevant rows.
The second criterion, on the other hand, helps me select from what has already been filtered, whether there has been a second delivery or not, and thus tells me the number of formats that were delivered in the last delivery.
However, not everything is reordered at the same time, and therefore some cells are filled or not.
The second criterion thus selects formats that were delivered once but have not been reordered a second time.

In brief:
rows = objects (column A) + sub-categories (column B)
columns = 1st (column C), 2nd (column D), ... delivery
objective = count the number of sub-categories that have been delivered once (cells in column C filled), and which have not been delivered a second time (cells in column D empty).

I apologize for explaining this in text, but privacy options do not allow me to share the file.

lelion4 · Answer

Subject resolved, apparently it’s the function that does not allow to perform a logical test. However, that’s what I was asking for.

jacki · Answer

it works with "<> " "<>space"

Excel formula: countifs and criteria "not blank"

5 answers

Delivery address track718

Dymo letratag ribbon blockage

Mouse wheel that changes the sound???

My google chrome homepage is shifted to the right.

Notice shows wr30 m

Keyboard locked: what to do?

[grouped subject] review of vova: is this site reliable?

Asus: my battery won't charge anymore.

How to know if the floryday shopping site is really reliable?

My samsung tv turns off and on again.