Help with a formula

[Captain Randy]

I want to look up && in row N1:N431 and count how many && that matches ### (in row O1:O431)and
In row P1:P431 matches ^^^.
The reason I’m showing && ### and ^^^ these represents symbols that are not numbers or letters.
My end results would be to count how many , “&& ### ^^^” are in the ranges as above.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
=Countif(O1:O431,Matches “J4 and K5”) will not work..
Should we use Lookup nestled with Match or Count Match ?
I’m lost !!
Thank You for any help you may be able to apply.
Randy

 

[VoG]

Is it?

=SUMPRODUCT(--(N1:N1431="&&&"),--(O1:1431="###"),--(P1:P1431="^^^"))

 

[AlphaFrog]

Or if you have Excel 2007 or later...

=COUNTIFS(N1:N1431, "&&&", O1:1431, "###", P1:P1431, "^^^")

 

[Captain Randy]

Or if you have Excel 2007 or later...

=COUNTIFS(N1:N1431, "&&&", O1:1431, "###", P1:P1431, "^^^")

Thank You, "VoG and Alphafrog" for your input and help..
I am working with Excel 2007.

 

[Captain Randy]

Hello Alphafrog
Thank You for the formlue;
=COUNTIFS(N1:N1431, "&&&", O1:1431, "###", P1:P1431, "^^^")

I appliyed it and I still get 0.

So I did this formule
=COUNTIFS($N$1:$N$431,"=n435",$O$1:$O$431,"=o432",$P$1:$P$431,"=X436")

I still get 0 as a return.. Do you have any thoughts as to why I'm having this kind of trouble?
Thank You very much for your input.
Randy

 

[rickstie]

Looks like one too many "&" to me. Try:
=SUMPRODUCT(--(N1:N1431="&&"),--(O1:1431="###"),--(P1:P1431="^^^"))

 

[AlphaFrog]

With your the COUNTIFS formula, all three conditions have to be True in a given row for it to count as one for that row. Is that what you want?

Can you better explain; "... these represents symbols that are not numbers or letters"?


Edit:
Or as rickstie points out...
=COUNTIFS(N1:N1431, "&&", O1:1431, "###", P1:P1431, "^^^")

 

[Captain Randy]

Hello Alphafrog
With your the COUNTIFS formula, all three conditions have to be True in a given row for it to count as one for that row. Is that what you want?
Yes Sir, in the first row I want to count how many symbols there are. And in the second row how many symbols there are that I want to count. And the same with the third row.

Can you better explain; "... these represents symbols that are not numbers or letters"?
Yes sir, they are symbols cause the font is not letters or numbers they are signs, Like H is the symbol for Mars. I'm working with a font style that is named AlmaFont.
I hope this helps us to figure it out. Once again, "Thank You for your help.
Randy

 

[AlphaFrog]

I understand your using a font to display the symbols and that's fine.

When you select a cell in column N, do you see exactly this...
&&
...in the formula bar?

The same with column O, you should see exactly this (no quotes)...
###
...in the formula bar.

And the same with column P, you should see exactly this (no quotes)...
^^^
...in the formula bar.

 

[Captain Randy]

Hello AlphaFrog
I was working with this Formula;
=COUNTIFS($N$1:$N$431,"=n435",$O$1:$O$431,"=o432",$P$1:$P$431,"=X436")

I removed all of the " and = signs.
Now the Formule reads;
=COUNTIFS($N$1:$N$431,N435,$O$1:$O$431,O432,$P$1:$P$431,X435)
and on the first two rows it seems to be working as it should.
I want to say "THANK YOU" for your time and help.
At 68 years old it dose take me a little work getting some of this stuff figure out.
AlphaFrog Thank You, Sir for your help.

Best to to you, Randy