Excel - Using IF statement to add 1 to total

Office softtware like Excel is used by millions across the world to store, share and analyze data. Excel comes loaded with inbuilt formulas that can be customized and combined with each other to achieve the desired results. One such example is to use the IF statement which incorporates conditional statements. The user can combine IF statement with other functions to add in a conditional statement based upon which the outcome of the formula would differ. These conditions can be based either on some text or numeric value which the formula would automatically check for.


I am trying to get a formula to add + 1 to a total cell, based on the word typed. Example: If I type the word 'Duty' in cells B3:B18 then add + 1 to cell B35. If there are 6 entries of duty then 6 should show in B35. However, if there is another word such as 'Leave' then I do not want it to count. I would like those tallied in B36. Is there a way to do this?


To count how many times the word "Duty" appears in the range B3:B18 use this formula in B35:
confirm this formula by pressing CTRL+Shift+Enter.

Do the same for the word "Leave" in B36 by replacing the word "Duty" by "Leave" in the formula.


Thanks to Trowa for this tip on the forum.
Published by aakai1056. Latest update on November 8, 2012 at 01:43 PM by Jeff.
This document, titled "Excel - Using IF statement to add 1 to total," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Excel - Comparing columns and returning value
Excel - Arrow keys stopped working