Re: Multiple Count Condition

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "PCLIVE" <pclive(RemoveThis)@cox.net>
Date: Wed, 5 Mar 2008 16:31:14 -0500

One possible way:

=SUMPRODUCT(--('Grindex 2008'!AB1:AB100="Jan-2"),--('Grindex
2008'!Y1:Y100="Jan-D"))+SUMPRODUCT(--('Grindex
2008'!AB1:AB100="Jan-3"),--('Grindex 2008'!Y1:Y100="Jan-D"))

HTH,
Paul

--

"Jay" <Jay@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5477F33E-F5AC-4ED8-A214-6592BAED9829@xxxxxxxxxxxxxxxx

Hello all,

I'm trying to create a multiple condition count and I can't get it to work
using all the examples I've found. I'm hope someone can help me out.

Here's the formula I've trying to manipulate (unsuccessfully):
=COUNT(('Grindex 2008'!AB:AB="Jan-2")*('Grindex
2008'!AB:AB="Jan-3")*('Grindex 2008'!Y:Y="Jan-D"))

So if (column AB = "Jan-2" OR column AB = "Jan-3") AND column Y = "Jan-D"
then count the row.

I'm drawing a complete blank. Anyone know the correct format? I can't
see
to find a good example on how to structure the formula.

Thanks,
Jay
--
Disregard, this is so I can find my post later.
***postedbyJay***

Follow-Ups:
- Re: Multiple Count Condition
  - From: Jay

Prev by Date: RE: Bolding using VBA
Next by Date: RE: SaveWorkbookAsToday()
Previous by thread: RE: Evalulate previous cell
Next by thread: Re: Multiple Count Condition
Index(es):
- Date
- Thread

Relevant Pages

Re: Multiple Count Condition
... specify the rows in the formula? ... Disregard, this is so I can find my post later. ... I'm drawing a complete blank. ... Anyone know the correct format? ...
(microsoft.public.excel.programming)
Re: Multiple Count Condition
... Disregard, this is so I can find my post later. ... "Jan-D" ... I'm drawing a complete blank. ... Anyone know the correct format? ...
(microsoft.public.excel.programming)