Apple Intelligence is now available on iPhone, iPad, and Mac!
hi there fellas
weird question for today I know
I've tried many solutions but none worked
I can rearrange the way of setting thing like changing text to numbers and all but was I need is
= -> Count all blanks in Have that have a "." in Want
== -> Count all "." in Have that have "." in Want
=== -> Count all "." in Want that have blank in Want
is there any solution to this???
MacBook Air 13″
A syntax error from what looks like a perfectly correct function usually means the user is in a region where the decimal separator is a comma. When this is the case, the parameters in functions need to be separated by semicolons, not commas.
=COUNTIFS($E;"";$D;".")
A syntax error from what looks like a perfectly correct function usually means the user is in a region where the decimal separator is a comma. When this is the case, the parameters in functions need to be separated by semicolons, not commas.
=COUNTIFS($E;"";$D;".")
=COUNTIFS(E,"",D,".")
=COUNTIFS(E,".",D,".")
=COUNTIFS(E,".",D,"")
Some of your cells in column E contain "\" which will not get counted as "have". Only cells with "." will get counted. If you want all non-blank cells to be counted,
=COUNTIFS(E,"",D,"<>")
=COUNTIFS(E,"<>",D,"<>")
=COUNTIFS(E,"<>",D,"")
Or you could use checkboxes in the "have" and "want" columns instead of text and it would be
=COUNTIFS(E,FALSE,D,TRUE)
=COUNTIFS(E,TRUE,D,TRUE)
=COUNTIFS(E,TRUE,D,FALSE)
In all these formulas I did E (have) first then D (want) because that is how you described it in your first post, as in Count all blanks in Have that have a "." in Want. But this is opposite to the wording in column G of your table. Switch them around if you want them to be in the same order as the wording in your table.
There's an easy solution to this - COUNTIFS()
You're probably familiar with COUNTIF(), which takes a range and a comparison value and counts the matches (e.g. 'Have', '=.")
The next level is COUNTIFS() which takes multiple ranges and comparison values and counts the ones that match all.
For example:
> Count all blanks in Have that have a "." in Want
=COUNTIFS($E,"=",$D,"=.")
This will count all the cells where the value in column E is empty ( '=' nothing), AND where column D is a ".' ('=.')
> -> Count all "." in Have that have "." in Want
=COUNTIFS($E, "=.", $D, "=.")
You can use this for any combination of haves/wants, and you can string as many comparisons as you like.
> I've tried writing which the app gives me the autocompletion
=COUNTIFS($Have,'=.',$Want,'=.')
and still doesn't work
Then there's something wrong with either the data, or something else we're not seeing.
There's no reason why that formula wouldn't work, given the information you posted earlier.
What's the error it gives you? Does it work with only one pair of comparisons?
I did already had knowledge about the CountIfS
I didnt knew about the the '='
even thought all your options give me Syntax Error
=COUNTIFS($E,"=",$D,"=.") - error
=COUNTIFS($E,'=',$D,'=.') - error
=COUNTIFS($E,"=";$D,"=.") - error
=COUNTIFS($E="=",$D="=.") - 1 (no matter what I change its always 1)
I've tried writing which the app gives me the autocompletion
=COUNTIFS($Have,'=.',$Want,'=.')
and still doesn't work
> ... usually means the user is in a region where the decimal separator is a comma
Oh, good catch. I really wish there was some standard that could be applied, or that Numbers was smart enough to accept both options.
Weird count blanks in B if A is .
