HOW DO YOU PROPERLY FORMAT A CELL

[Gifmaster]

MY CELL LOOKS LIKE THIS “=COUNTIF(B13:B100,1)”
i WANT TO REPEAT IT 5 MORE TIMES THRU COL B,C,D,E,F
SOMETHING LIKE THIS
=COUNTIF(B13:B100,1)(C13:C100,1)(D13:D100,1)(E13:E100,1)
This Layout Does Not Work Need Help in getting it to work.

If You Can Help Much Thanks
Gifmaster

[mariosv]

All in UPPERCASE is like shouting in the net. And make your text to be even less legible.

[mariosv]

Take a look to this thread.

COUNTIF used finding words in multiple columns

I’m basically trying to find the condition when “racecar” and “shoe” are both in the same row, but in two different columns. Most of my searching has brought me to similar questions for Open Office, but with solutions that don’t appear to work. I get Error 502 for this formula: =COUNTIF((H2:H118,“racecar”)*(I2:I118,“shoe”)) SUMPRODUCT has also been recommended, but I don’t think that’s what I’m looking for.