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???
 

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

Counting multiple criteria across columns and rows???
 

ISAF Media Analysis;226702 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

Also try
=SUMPRODUCT((A1:A6="neg")*(B1:B6="chi")*(C1:C6="ci ty")*D1:D6="city"))

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


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=62983