Formula to count text with two conditions.

F

Folletti

Can someone help me figure out how to get a count on specific text items
that meet two conditions? I have two columns. Each column has approximately
five different groups of text in them. I need a count on the number of items
from column two that match up with specific text from column one. For
example, column one has LA, Foreign, and States. Column two has yes, no, and
maybe. I need the count on how many yesses there are that match up with
States.
I'm using Excel Office 2003.

I know this is probably confusing...thanks so much for any help you can give
me!
 
M

Mike H

Hi,

I'm not sure I understand but try this

=SUMPRODUCT((A1:A100="States")*(B1:B100="Yes"))

Mike
 
F

Folletti

Thank you so much!! I've been trying to figure this out for weeks, and
finally foudn this site. You're a lifesaver!
 

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

How to center adjust text above and image in a two column document. 1
Select Text to End of Footnote 9
How to get a count on specific items that meet two conditions. 1
Mail Merge Help 1
Cumulative formula for word table 0
Macro to Select text from a point given to a specific word 2
Pivot Table Counting Text Data 0
Count Based on Comparison with Two Fields 2

Top