# Do not laugh at my formula! Countif question.

##### MrExcel MVP
Hi Tom,

sumproduct is what you need:
Book4.xls
ABCDE
130-Aug-02NewSystem31/08/2002
202-Sep-02NewSystem4/09/2002
303-Sep-02ThirdPartyRepairCounts
404-Sep-02NewSystemWarrentyRepair1
604-Sep-02WarrentyRepairThirdPartyRepair1
8
9
10
Sheet2

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
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
ABCDEF
1DateItem31-Aug-02ItemCount
230-Aug-02NewSystem04-Sep-02NewSystem2
302-Sep-02NewSystemThirdPartyRepair1
504-Sep-02NewSystemWarrantyRepair1
704-Sep-02WarrantyRepair
806-Sep-02NewSystem
Sheet1

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

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

Replies
5
Views
766
Replies
4
Views
822
Replies
10
Views
797
Replies
3
Views
325
Replies
16
Views
2K

1,221,199
Messages
6,158,485
Members
451,495
Latest member
Jatin Bhagdev

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back