Home > Forum Home > Automating Data Analysis Tasks > Adding up interchanging word Share

Adding up interchanging word

Excel Help for Adding Up Interchanging Word in Automating Data Analysis Tasks


Forum TopicPost Reply Login

Adding Up Interchanging Word

Rate this:
(3/5 from 1 vote)
ConfusedI 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.
 hit me up
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Happy
Rate this:
(3/5 from 1 vote)
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.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Adding up interchanging word in the