How to SUM just positive values in month x

[Jarke]

Hi brilliant people!

I want to sum just the positive transactions in a month, my current code to sum the result of the month is =SUMPRODUCT((MONTH(Logg!$C$24:$BN$24)=C75)*(YEAR(Logg!$C$24:$BN$24)=2016)*(Logg!$C$60:$BN$60))

But i want to sum only the positive numbers, to later get an average of it. My values are in Row 60 and dates is in row 24.


Thanks alot for trying to help, appreciate all you can come up with, cheers

 

[JoeMo]

Try:

=SUMPRODUCT((MONTH(Logg!$C$24:$BN$24)=C75)*(YEAR(Logg!$C$24:$BN$24)=2016)*(Logg!$C$60:$BN$60>0),Logg!$C$60:$BN$60)

 

[Jarke]

Beautiful! Error first but changed the comma "," in the end of the code to a "*" and then it worked, Thanks alot!


To get the average of the positive transactions, i need to divide that code by a code that counts how many positive transaction it was in that same month, can you do this?

Thanks again!

 

[Jarke]

I solved it by myself, thanks for help mate! Cheers

 

[JoeMo]

Beautiful! Error first but changed the comma "," in the end of the code to a "*" and then it worked, Thanks alot!


To get the average of the positive transactions, i need to divide that code by a code that counts how many positive transaction it was in that same month, can you do this?

Thanks again!

You should not need to replace the comma with a *.

For the count try this array formula:

=SUM(IF((MONTH(Logg!$C$24:$BN$24)=C75)*(YEAR(Logg!$C$24:$BN$24)=2016)*(Logg!$C$60:$BN$60>0),1,0))

CONFIRM with ctrl+shift+enter, not just enter.