title: Count and sum up data in excel
body: <p><a href="https://i.stack.imgur.com/ndOjH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ndOjH.png" alt="enter image description here" /></a></p>
  <p>Hi everyone, I want to sum up the number of ok and error in all column in excel. For column1, the answer should be (1 OK, 1 error) . For column2, the answer should be (2 error). How do I count the column data like this? Can I use Pivot table to do this?</p>