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

How to center adjust text above and image in a two column document. 1
Formula to count text with two conditions. 3
formula to count text entries and return text with most entries 12
Formula- Count of items that meet a specific range criteria 4
count duplicats, display incremental count, restart count at changein value 2
how to count the number of times text occurs based on condition 3
Count Blank Cells with Conditions 3
count unique items 1

Top