How to get a count on specific items that meet 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 apple, orange, and pear. Column two has yes, no, and maybe.
I need the count on how many yesses there are that match up with pear. I'm
using Excel Office 2003.

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

Michael Bauer [MVP - Outlook]

I'm sure it's not confusing at all for our Excel gurus. You might contact
them in an Excel newsgroup (e.g. microsoft.public.excel), this one is for
Outlook.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Tue, 28 Oct 2008 07:26:05 -0700 schrieb Folletti:
 

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

Formula to count text with two conditions. 3
count duplicats, display incremental count, restart count at changein value 2
how to count the number of times text occurs based on condition 3
formula to count text entries and return text with most entries 8
How pull ID#s that meet specific "yes" requirements 3
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Count Based on Comparison with Two Fields 2
How do I overlay variable items on an imported image used for a re 19

Top