Hello folks, need som help with finding value on a certain date to calculate monthly change!
I want to calculate the percentage changed every month, and so i got transactions every month, but not always is it the first or last in the month, to find right dates? could perhaps go from last transaction previous month to last transaction this month to get what happened within the month.
This is my code to sum what happened during the month.
=SUMPRODUCT((MONTH(Logg!$C$24:$BN$24)=C75)*(YEAR(Logg!$C$24:$BN$24)=2016)*(Logg!$C$60:$BN$60))
And obviously i need to subtract or add the ingoing "bankaccount" with the transaction sum of the month, and then divide this with the ingoing bankaccount value to get the percentage changed.
Nuff said, i also have the bank value being changed with each transaction and date, and i want a code to find the right date, and thereby the right value.
Ooor, as i have the "bankvalue" after each transaction, a code that will find the first logged bankvalue of the month and the last, this could do the trick. But how will i code this?
Hope i made it clear enought, please ask otherwise
Best regards
I want to calculate the percentage changed every month, and so i got transactions every month, but not always is it the first or last in the month, to find right dates? could perhaps go from last transaction previous month to last transaction this month to get what happened within the month.
This is my code to sum what happened during the month.
=SUMPRODUCT((MONTH(Logg!$C$24:$BN$24)=C75)*(YEAR(Logg!$C$24:$BN$24)=2016)*(Logg!$C$60:$BN$60))
And obviously i need to subtract or add the ingoing "bankaccount" with the transaction sum of the month, and then divide this with the ingoing bankaccount value to get the percentage changed.
Nuff said, i also have the bank value being changed with each transaction and date, and i want a code to find the right date, and thereby the right value.
Ooor, as i have the "bankvalue" after each transaction, a code that will find the first logged bankvalue of the month and the last, this could do the trick. But how will i code this?
Hope i made it clear enought, please ask otherwise
Best regards