the formula is trying to find out how many people like blue.
2007-01-22 05:43:33 · 3 answers · asked by ? 1 in Computers & Internet ➔ Software
You are missing the quotes before the amphersand.
="THERE ARE " & COUNTIF(E3:E22, "B") & " THAT LIKE BLUES"
2007-01-22 05:52:06 · answer #1 · answered by MrLobito 2 · 0⤊ 0⤋
Well you need quotes around there are and don't capital all on the count if just the first letter everything else look right. I have never seen there are before count if. The Formula i might would look like this:
=Countif(e3:e22,"B","Blue")
2007-01-22 13:55:55 · answer #2 · answered by Kyle S 2 · 0⤊ 0⤋
First thing I see, if you typed it right, is that there is no quote after "are" and before the "& Count" so it would be treating the &Countif(xxx)& as part of the string, not as a formula.
2007-01-22 13:48:39 · answer #3 · answered by dewcoons 7 · 1⤊ 0⤋