Sharepoint List - Calculations for Row

%3CLINGO-SUB%20id%3D%22lingo-sub-2294896%22%20slang%3D%22en-US%22%3ESharepoint%20List%20-%20Calculations%20for%20Row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2294896%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20sharepoint%20list%20which%20which%20obtains%20a%20quality%20assurance%20form%20from%20MS%20Forms.%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20this%20form%20it%20lists%20out%20if%20a%20question%20had%20the%20result%20of%20Pass%20or%20Fail%20throughout%20the%20row.%20I%20need%20to%20calculate%20how%20many%20times%20Pass%20appears%2C%20how%20many%20time%20Fail%20appears%2C%20and%20then%20%5BTotal%20Pass%2F%20(total%20pass%20%2B%20total%20fail)%5D%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20I%20have%20this%20done%20within%20Excel%20using%20Countif%20and%20then%20a%20general%20function%2C%20but%20I%20would%20like%20to%20do%20this%20within%20sharepoint%20lists.%20So%20far%20I%20have%20only%20been%20able%20to%20find%20instructions%20on%20how%20to%20do%20Counting%20calculations%20for%20columns.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%20to%20do%20or%20are%20there%20any%20alternate%20solutions%3F%20My%20goal%20is%20to%20have%20everything%20housed%20within%20SP.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2294896%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a sharepoint list which which obtains a quality assurance form from MS Forms. 

In this form it lists out if a question had the result of Pass or Fail throughout the row. I need to calculate how many times Pass appears, how many time Fail appears, and then [Total Pass/ (total pass + total fail)] 

 

Currently I have this done within Excel using Countif and then a general function, but I would like to do this within sharepoint lists. So far I have only been able to find instructions on how to do Counting calculations for columns.  

 

Is this possible to do or are there any alternate solutions? My goal is to have everything housed within SP.  

0 Replies