Do not laugh at my formula! Countif question.

[PaddyD]

Hi Tom,


sumproduct is what you need:

Book4.xls
	A	B	C	D	E
1	30-Aug-02	NewSystem		31/08/2002
2	02-Sep-02	NewSystem		4/09/2002
3	03-Sep-02	ThirdPartyRepair			Counts
4	04-Sep-02	NewSystem		WarrentyRepair	1
5	04-Sep-02	Upgrade		NewSystem	2
6	04-Sep-02	WarrentyRepair		ThirdPartyRepair	1
7	06-Sep-02	NewSystem		Upgrade	1
8
9
10
Sheet2

Paddy

 

[Aladin Akyurek]

Let A1:B8 house the sample, D1 the start date, and D2 the end date.

Create a unique list from B1:B8 using Advanced Filter in E fro E1 on.

In F2 enter & copy down:

=SUMPRODUCT(($A$2:$A$8>=$D$1)*($A$2:$A$8<=$D$2)*($B$2:$B$8=E2))

aaMultCondCount TsTom.xls
	A	B	C	D	E	F
1	Date	Item		31-Aug-02	Item	Count
2	30-Aug-02	NewSystem		04-Sep-02	NewSystem	2
3	02-Sep-02	NewSystem			ThirdPartyRepair	1
4	03-Sep-02	ThirdPartyRepair			Upgrade	1
5	04-Sep-02	NewSystem			WarrantyRepair	1
6	04-Sep-02	Upgrade
7	04-Sep-02	WarrantyRepair
8	06-Sep-02	NewSystem
Sheet1

Aladin

 

[Legacy 98055]

Hi Guys.
I appreciate the help from both of you.
Works perfectly!
Tom

 

[XL-Dennis]

Tom,

OT
"Do not laugh at my formula! Countif question."

Why should we laugh?

What I found out in this context is that
there exist no stupid questions but stupid answers to relevant questions

Kind regards,
Dennis