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.
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?
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".
Need more help with Excel? Check out our forum!
- Excel - Using IF statement to add 1 to total
- Formula to add 1 with IF statement [solved] > Forum - Excel
- If a cell contains any text then add a value [solved] > Forum - Excel
- Add an area code on Android > Guide
- Jio Adds 1,000 Subscribers Per Minute
- How to display multiple columns in a validation list
- How to insert file path in excel: cell, sheet
- Convert numbers to words in Excel: without VBA, formula
- How to copy a Macro into a blank cell
- How many IF statements can you nest in Excel
- How to apply a function to multiple sheets on Excel
- How to perform a partial cell match in Excel?
- How to change author name in Excel: spreadsheet, VBA
- How to insert GIF in Excel: 365, sheet, VBA
- How to take screenshot in Excel: shortcut, sheet, cell
- How to enable VBA in Excel: Mac, Office 365
- Copy data from one excel sheet to another: automatically
- Change date format in Excel: to dd/mm/yyyy, mm/dd/yyyy
- Fix arrows keys in Excel: Scroll lock, alternative method