countif with multiple conditions

's Computer Specifications

I have a list of data in coloumns A and B. I need to write a countif style
formula for if column A has one set of data in it while at the same time
column B has another set of data. So it should only count if the conditions
for column A and the conditions in column B are met.

's Computer Specifications

Try:
=SUMPRODUCT(--(A1:A1000="your condition"),--(B1:B1000="your condition"))

"Chad Portman" wrote:

> I have a list of data in coloumns A and B. I need to write a countif style
> formula for if column A has one set of data in it while at the same time
> column B has another set of data. So it should only count if the conditions
> for column A and the conditions in column B are met.
>

's Computer Specifications

see your other post

--
Biff
Microsoft Excel MVP

"Chad Portman" <(E-Mail Removed)> wrote in message
news:5D4333E3-C506-4FEE-8FEA-(E-Mail Removed)...
>I have a list of data in coloumns A and B. I need to write a countif style
> formula for if column A has one set of data in it while at the same time
> column B has another set of data. So it should only count if the
> conditions
> for column A and the conditions in column B are met.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF with multiple conditions?	=?Utf-8?B?RXJpYw==?=	Microsoft Excel Worksheet Functions	7	17th Oct 2006 02:25 AM
CountIf with multiple conditions	=?Utf-8?B?VGhvcg==?=	Microsoft Excel Worksheet Functions	2	22nd Sep 2006 08:59 PM
COUNTIF - multiple conditions	allphin	Microsoft Excel Worksheet Functions	4	18th Sep 2005 04:05 PM
Using CountIF with multiple conditions	Susan Lammi	Microsoft Excel Worksheet Functions	9	19th Oct 2004 01:18 AM
COUNTIF ? with multiple conditions	GW	Microsoft Excel Misc	2	30th Sep 2003 01:15 AM