Solved

Sum Daily - SumProduct

Posted on 2016-09-20
4
38 Views
Last Modified: 2016-09-20
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
0
Comment
Question by:pdvsa
  • 3
4 Comments
 
LVL 30

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 500 total points
ID: 41806630
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
 
LVL 30

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41806653
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
 

Author Comment

by:pdvsa
ID: 41806737
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
 
LVL 30

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41806747
You're welcome.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question