A calculation to count all cells ='D' where the offset cells in range have dates <= todays date

's Computer Specifications

I am working on a scheduling system in Excel 2002.

In cells A12: A376 I have the dates from 1/1/2004 > 12/31/2004 and in column B12:B376 the characters can be "D", "E" or "N" (day, evening, night).
I want to put a calculation in cell B8 that counts the # of "D"s in the range B12:B376 where the corresponding date in column A is <= the current date (=now()).

Can anyone help me?

TIA, AlanN

's Computer Specifications

Hi Alan

Try
=SUMPRODUCT(--(B12:B376="D")*(A12:A376<=Today()))

--
Regards
Roger Govier
"AlanN" <(E-Mail Removed)> wrote in message news:8G9Sb.57439$(E-Mail Removed)...
I am working on a scheduling system in Excel 2002.

In cells A12: A376 I have the dates from 1/1/2004 > 12/31/2004 and in column B12:B376 the characters can be "D", "E" or "N" (day, evening, night).
I want to put a calculation in cell B8 that counts the # of "D"s in the range B12:B376 where the corresponding date in column A is <= the current date (=now()).

Can anyone help me?

TIA, AlanN

's Computer Specifications

"AlanN" <(E-Mail Removed)> wrote in message
news:8G9Sb.57439$(E-Mail Removed)...
I am working on a scheduling system in Excel 2002.

In cells A12: A376 I have the dates from 1/1/2004 > 12/31/2004 and in
column B12:B376 the characters can be "D", "E" or "N" (day, evening, night).
I want to put a calculation in cell B8 that counts the # of "D"s in the
range B12:B376 where the corresponding date in column A is <= the current
date (=now()).

Can anyone help me?

TIA, AlanN

=SUMPRODUCT((B12:B376="D")*(A12: A376<=TODAY()))

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count Unique Cells, within a date range (dates stored in separatecolumn).	Matt	Microsoft Excel Discussion	3	15th Jul 2010 09:59 AM
Sum a range of cells starting from an offset date list from TODAY()	jeff.taylor@virgin.net	Microsoft Excel Worksheet Functions	3	5th Nov 2006 12:19 PM
Count cells within a date range	=?Utf-8?B?RGV3YXluZQ==?=	Microsoft Excel Misc	7	20th Aug 2006 04:40 AM
Problem with Range.Cells.Offset and Range.Cells( row + offset, column)	erazmus@actrix.co.nz	Microsoft Excel Programming	1	22nd Aug 2005 03:31 AM
Count number of cells that fall within a range of dates	mmay321	Microsoft Excel Discussion	3	8th Aug 2005 10:29 PM