# Sum Daily - SumProduct

Hello,

I hav a formula that sums daily
however, I wish it to return the sum one time only.
I need this because I wish to sum the column.

formula:
=SUMPRODUCT((\$M\$2:\$M\$37<>"")*(DAY(\$M\$2:\$M\$37)=DAY(M2))*\$L\$2:\$L\$37)

Please see attached and I think you can see what I mean.

thank you
EE_Daily.xlsx
###### Who is Participating?

Excel & VBA ExpertCommented:
Try this.....

In J2
``````=IF(I2=I3,"",SUMIF(\$I\$2:\$I\$37,I2,\$H\$2:\$H\$37))
``````
and copy down.
0

Excel & VBA ExpertCommented:
Also what you need can also be achieved with the help of Pivot Table.
Refer to the attached where col. J contains the formula and to the right of the data set you will find a Pivot Table with the desired output, much easy to visualize the Net Amount as per the dates.

See if that helps.
EE_Daily.xlsx
0

Project financeAuthor Commented:
Hi there...
Ahh yes a pivot.  I forgot about that option.  Thank you for reminding me.  😀

Havent tried formula yet but will in a bit.  I am confident itnis correct tho so i will close it out.
0

Excel & VBA ExpertCommented:
You're welcome.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.