please help me with this! I'm trying to add every data on a per date basis but my problem is that the date requires to be at the right column of the data to be extracted. you may refer to the attached file.
I get a different answer for 01/01 than you:
I used: =SUMPRODUCT((RIGHT(I$2:I$50,5)=K2)*(H$2:H$50))
and have included the second group of 01/01 which I assume you left out in error
thanks for your reply, I just got a little messed up since I was being pushed to finish these on time. but your formula SUMPRODUCT works. I just made some minor edition though, thanks a lot anyway!!