Sum function in Microsoft Lists

Question

Hi

I used power automate to generate a list from a form. The form has 10 questions and every question has these 6 options.
Option 1 - 1
Option 2 - 2
Option 3 - 3
Option 4 - 4
Option 5 - 5
Option 6 - N/A

I would like to sum the outcome of the questions in lists.
But I can't seem to find a formula (something like sumif in Excel) that can count the numbers (outcome 1-5) and ignore the text "N/A" where necessary)

Answer 1

Hey,

your question is not related to Operations Manager (SCOM) and judging by the tags on the Q&A platfomr there is no category for Power Automate.
Still, there is a huge community and I would suggest that you post this same question in the Power Automate Forum here:

Microsoft Power Automate Community
https://powerusers.microsoft.com/t5/Forums/ct-p/FL_Comm_Forums

There you will find an adequate answer for sure.

I hope I could help you out!

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)
Regards
Stoyan Chalakov