PDA

View Full Version : adding up interchanging word in a single cell



JordanGoodch
07-21-2010, 08:23 PM
i have a spreadsheet designed to track the progress of motors, unfortunately im stuck as how to track the amount of times the motor has been started.

ive got it set so that it has RUN and OFF in the coloumn 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.

EDGE
07-22-2010, 05:17 AM
To count the number of times the word "RUN" appears in a column you can use COUNTIF.

Example: Place the following in a cell

=COUNTIF(M:M,"RUN")