I have a spreadsheet designed to track the progress of motors, unfortunately I'm stuck as how to track the amount of times the motor has been started.
I've got it set so that it has RUN and OFF in the column to the right indicating whether its running or not.
Is there any formula I can use that will add up the amount of times the word run appears. or changes from off to run.
The motor ID is column A and the 'Running' is Column M with the start up count in Column N. The motor running is set via formula from a program called PI.
To count how many times a word appears in the column (such as "RUN" in your case) you can use the COUNTIF function which takes he form of:
=COUNTIF(Cell range to count, text criteria)
You may also want to look at the SUMIF funtion which will total the values in another column that have the same row criteria as "RUN" or "OFF". This simply takes and extra parameter at the end which is the columns to range to sum.
