View Single Post
  #1   Report Post  
paper cutter
 
Posts: n/a
Default How do I count the number of brackets within a formula (cell)?

I am reviewing vehicle usage. An example of a formula under review is as
follows: =(5-2)+(6-2)+(8-3). This will add up the kilometers. The 2nd
column (the problem), I want to calculate is the number of trips. Each
bracket is considered one trip. In the above example that would be a total
of 3 trips and total of 12 km.