Counting multiple criteria across columns and rows???

  • Thread starter ISAF Media Analysis
  • Start date
I

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rows to columns with multiple sets 1
Splitting Text from single cell in column across multiple Columns 3
Counting number of rows based on mutiple criteria 2
Counting rows that meet multiple criteria 5
Lookup Across Multiple Rows / Columns 5
Transposing 4-row clumps of name and address in Column A to Columns A,B,C,D 2
Summing Rows with Multiple Criteria 2
counting text across multiple columns 3

Top