I need to add up all positive values in F column and display the value in an empty cell.
I have used logic in XML plenty times, and noticed excel has the feature, so that is where I started, but can't find much info on it. Something like "If any number in column F is >0, add it together and put the sum in this cell")
or maybe there is another way to do it.
I have used logic in XML plenty times, and noticed excel has the feature, so that is where I started, but can't find much info on it. Something like "If any number in column F is >0, add it together and put the sum in this cell")
or maybe there is another way to do it.
-
=SUMIF(F1:F301,">0")