# Need help with formula

#### amir2000

##### New Member
Hi All

I have a table with 3 columns of dates and then a column with Set # that I
feel in the box #.
I need to see how many items processed for each set per day.

Example:
http://www.amir2000.nl/1.doc

The problem is that it counts the correct amount but not with the correct
dates.
The formula that I use is:
=SUMPRODUCT(--(\$I\$3:\$I\$8<>"")*((\$C\$3:\$C\$8=39601)+AND(\$E\$3:\$E\$8=39601)+AND(\$G\$3:\$G\$8=39601)))
Is anyone can help?
It is quiet urgent...
I'm trying to get help in amother forum you can have a look ant try to understand:

Many thanks in advance,

Amir

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

#### Dave Patton

##### Well-known Member
Hello Amir and welcome to the forum.

I did not tour the site to see your example.

I put the date of interest in a cell A3 and I read your question as the date must be in the 3 columns and the amount to be summed is column I.

=SUMPRODUCT(--(\$I\$3:\$I\$8<>""),--(\$C\$3:\$C\$8=A3),--(\$E\$3:\$E\$8=A3),--(\$G\$3:\$G\$8=A3),(\$I\$3:\$I\$8))

#### amir2000

##### New Member
Hi ,
No it does not help.

Thanks,
Amir

Replies
3
Views
259
Replies
6
Views
404
Replies
1
Views
469
Replies
2
Views
302
Replies
1
Views
236

1,190,883
Messages
5,983,387
Members
439,841
Latest member
goodwillhunting

### 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.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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