General Question - Excel Formula Question

Hi everyone,

New to the site and I have a question regarding a formula that I am trying to create in Excel and was hoping someone could assist.

I am creating a Holiday spreadsheet for my work. I have one worksheet for each calendar month and one worksheet which gives an overview.

On each monthly worksheet I have one row for each employee and columns for each working day in that month. At the end of each row I have a total (with me so far )

When I enter the letter H into a cell to represent an annual leave day I want the total cell at the end of the row to count how many cells have H in them rather than doing it manually. So all the admin person needs to do is enter H in the appropriate cells for that month and the total is auto calculated.

Any help would be greatly appreciated

Let's pretend that you have a row consisting of cells from A1 to A30. If you have an H in any of these, I assume you want to display the count of H instances in that row. Here is what you do. Create a column for the total number of holidays (for this example use cell A31). Then type in The countif can be used with any single value that you like. Give that a try and let me know if it helps.