Counting multiple criteria across columns and rows???

[ISAF Media Analysis]

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

 

[muddan madhu]

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")*(D16="city"),))
*3

 

[Pecoflyer]

Hello,

I am having a great deal of difficulty with a formulas. I need
formula
that will count across multiple columns and rows. For example, base
on the
info below, if I wanted to only know what the count was for "NEG" fro
column
A, plus "CHI" from column B, plus "CITY" from columns C and D. Base
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

Also try
=SUMPRODUCT((A1:A6="neg")*(B1:B6="chi")*(C1:C6="city")*D16="city"))

Adapt ranges to fit. They must all be the same length, no entir
columns like B:B are allowe

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste