Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting multiple criteria across columns and rows??? | Excel Worksheet Functions | |||
Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
Counting Multiple columns using single criteria | Excel Worksheet Functions | |||
Help w/ counting multiple columns based on IF criteria | Excel Worksheet Functions | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) |