I have a spreadsheet maintained in Numbers where I record my practices at the range, which lists type of weapon (pistol, rifle, shotgun), as well as the numbers of shots fired.
I am readily able to calculate the total, but want a more granular overview.
The column recording numbers of shots is called "skudd", while the one recording type of weapon is called type. The formula I've got right now is:
This should return something over 1500 shots, but currently returns the result 28. The number of times at the range shooting pistol is 18.