Hi,

I am looking to write a formula that counts the total number of marks of a question and sum them up together as a value in a column.

marks of a question may be identified by square brackets in a field (e.g. [1] means 1 mark, [2] means 2 marks)

A sample of the field looks like this:

"Study the diagram below.

a) Circle what happened to the amount of food in the bowl after a few days. [1]

b) Based on the diagram above, name one substance this animal needs so that it

remains alive. [1]"

The total number of marks for this question would be 2 ( there are 2 [1]s which sums up to 2)

I was thinking that I may count the string “[1]” but the formula does not seem to have this function. I would need to find another way to work around it.

Any inputs/ ideas would be very much appreciated.

Thank you in advance!