Adding up interchanging word

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

Adding Up Interchanging Word

Rate this: (3/5 from 1 vote)

	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.
	hit me up
	Posted by JordanGoodchild on 22 Jul 2010

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	The COUNTIF function 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 Excel Helper on 22 Jul 2010

Displaying page 1 of 1