SUMIF Nth cell with only positive numbers

[ibobo]

Hello,

I m trying to add SUMIF, there are positive and negative numbers, I would like to sum only positive numbers.

I tried this : "=SUMIF($F$1:$BR$1;1;IF(F4:BR4;">0"))" it show #VALUE!

I tried many some others way but still unsuccessful

thank you ))

Excel file : https://www.catupload.com/download/dd2c6f7d5a33e452ec1af170fc0e0569.html

 

[Tetra201]

Maybe

=SUMIFS(F4:BR4;$F$1:$BR$1;1;F4:BR4;">0")

 

[ibobo]

Maybe

=SUMIFS(F4:BR4;$F$1:$BR$1;1;F4:BR4;">0")

Tetra201 thanks you !! ))) work's perfectly

 

[Tetra201]

Glad to have helped.