Sum Date issues

[InventedTheMop]

Hey, I'm trying to sumif the sales a salesman made on a specific day. However, the dates yielded from our database have specific times on the end. How can I get my sumif formula to ignore the times and only concentrate on the actual date?

Sample:
=SUMIFS($B$2:$B$1000,!$A$2:$A$1000,F1,$D$2:$D$1000,G1)

In the above sample:

column B represents each individual sale made in the day.

column A represents the name of the employee who made each individual sale.

column D represents the range of dates and times at which point the sale was made.

F1 represents a specific employee's name

G1 represents a specific date

Please help!!

 

[mvptomlinson]

How about:

=SUMPRODUCT(--($A$2:$A$1000=F1),--(INT($D$2:$D$1000)=G1),$B$2:$B$1000)

 

[p45cal]

It didn't like:
=SUMIFS($B$2:$B$1000,$A$2:$A$1000,F1,INT($D$2:$D$1000),G1)
so:
=SUMPRODUCT(($B$2:$B$1000)*($A$2:$A$1000=F1)*(INT($D$2:$D$1000)=G1))

 

[InventedTheMop]

That worked perfectly. Thank you both for your quick replies.