Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
Hello,
I have the vector from the attached file with the input data.
I need to do both the sum and the total number of all positive elements from N22 (only positive). How can i do this?
Thank you,
Otilia
Solved! Go to Solution.
For whatever it may be worth here is a slightly shorter approach
Hello,
I managed to get the results I wanted for a larger matrix (see attached) with the help from both of you and it is greatly appreciated.
What i still don't understand is the functions you used for sum and count. For count you used the 'vector sum' function, for sum it's some sort of product. No wonder with the vector sum i couldn't get anywhere when i started this exercise. Why?
Thank you,
Otilia
It makes sense now.
Thank you.