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
pdvsaProject financeAsked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
Try this.....

In J2
=IF(I2=I3,"",SUMIF($I$2:$I$37,I2,$H$2:$H$37))

Open in new window

and copy down.
0
 
Subodh Tiwari (Neeraj)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
 
pdvsaProject 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
 
Subodh Tiwari (Neeraj)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.

All Courses

From novice to tech pro — start learning today.