your ex : A6 = NEG, B6 = CHI , C6 = City, D6 = City

how 3 ? I assumed that A6, B6 & C6 is matching so 1+1+1 = 3 ? is this
you are looking for ?

Array function use Ctrl + Shift + Enter

=COUNT(IF((A1:A6="neg")*(B1:B6="chi")*(C1:C6="city ")*(D1:D6="city"),))
*3


On Feb 12, 1:46*pm, ISAF Media Analysis
wrote:
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