Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Need Help with the SUMPRODUCT Function in Excel
=SUMPRODUCT(($B$2:$B$800>DATE(2013,4,1))*($B$2:$B$800<DATE(2013,4,5)))
A B
1 4/1/2013
2 4/2/2013
3 4/2/2013
4 4/2/2013
5 4/2/2013
6 4/2/2013
7 4/4/2013
8 4/4/2013
9 4/4/2013
10 4/5/2013
11 4/5/2013
12 4/8/2013
13 4/8/2013
14 4/8/2013
15 4/8/2013
16 4/8/2013
17 4/9/2013
18 4/9/2013
19 4/9/2013
20 4/9/2013
21 4/9/2013
The Value returned is 8 even though the answer is 11. I cant seem to figure out what I am doing wrong. Can somebody please help me.
J