Counting multiple criteria across columns and rows???
 

Hello,

I am having a great deal of difficulty with a formulas. I need a formula
that will count across multiple columns and rows. For example, based on the
info below, if I wanted to only know what the count was for "NEG" from column
A, plus "CHI" from column B, plus "CITY" from columns C and D. Based on the
below criteria the answer should be "3." Can anyone please help. Cheers.

A B C D
1 NEG NYC CITY CITY
2 NEG CHI STATE CITY
3 POS LA TOWN PARK
4 NEU DC VILLAGE OCEAN
5 POS DC HOME APARTMENT
6 NEG CHI CITY CITY

Counting multiple criteria across columns and rows???
 

=COUNTIF(A:A,"NEG")+COUNTIF(B:B,"CHI")+COUNTIF(C:D ,"CITY")

--
__________________________________
HTH

Bob

"ISAF Media Analysis" wrote in
message ...
Hello,

I am having a great deal of difficulty with a formulas. I need a formula
that will count across multiple columns and rows. For example, based on
the
info below, if I wanted to only know what the count was for "NEG" from
column
A, plus "CHI" from column B, plus "CITY" from columns C and D. Based on
the
below criteria the answer should be "3." Can anyone please help. Cheers.

A B C D
1 NEG NYC CITY CITY
2 NEG CHI STATE CITY
3 POS LA TOWN PARK
4 NEU DC VILLAGE OCEAN
5 POS DC HOME APARTMENT
6 NEG CHI CITY CITY