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???
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions |