Count cells equal to a value within a date range

[margamo]

Can some help me with this array formula:
{=SUM(DrugClass="HS051")*(OrderDate>=T4)*(OrderDate<T5)} I want to check for DrugClass equal to HS051 and then check if the OderDate is within a certain date range.

Any help would be greatly appreciated.
Thanks,
margamo

 

[margamo]

Somehow the formula didn't copy right it should be:
{=SUM(DrugClass="HS051")*(OrderDate>=T4)*(OrderDate
<T5)}

 

[NBVC]

Try clicking the Code button before and after inserting your formula. It's the < sign that is messing it up. I learned this myself recently.

 

[Joe4]

Try checking the "Disable HTML in this post" button.

 

[margamo]

{=SUM(DrugClass="HS051")*(OrderDate>=T4)*(OrderDate < T5)}]

 

[fairwinds]

Hi,

Like this?

If you use SUMPRODUCT you do not need to array enter.

Book1
	N	O	P	Q	R	S	T	U
1
2		HS049	2005-10-07
3		HS050	2005-10-08
4		HS051	2005-10-09			2	2005-10-10
5		HS051	2005-10-10				2005-11-10
6		HS051	2005-10-11
7		HS052	2005-10-12
8		HS053	2005-10-13
9		HS054	2005-10-14
10		HS055	2005-10-15
11
Sheet1

 

[margamo]

Thanks a lot: it worked great!
Margamo