2
Thanks

A few words of thanks would be greatly appreciated.

Excel - Using IF statement to add 1 to total

Excel is used to store, share and analyze data. It has inbuilt formulas that can be customized and combined with each other to achieve the desired results. For example, IF statement incorporates conditional statements. The user can combine IF statement with other functions to add in a conditional statement. These conditions can be based either on some text or numeric value which the formula would automatically check for.





Example

You are trying to get a formula to add + 1 to a total cell based on the word typed. If you 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 you do not want it to count, you would like those tallied in B36. Is there a way to do this?

Solution

To count how many times the word "Duty" appears in the range B3:B18 use this formula in B35:

=SUM(IF(B3:B18="Duty",1,0))


Confirm this formula by pressing CTRL+Shift+Enter.

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


Image: © Unsplash

2
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
Related
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 (ccm.net).

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!