pdvsa
asked on
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
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<>"
Please see attached and I think you can see what I mean.
thank you
EE_Daily.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
You're welcome.
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