# Get instant live Excel expert help with COUNT Function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I need help building a formula for the following: Master =Hotel name where there could be more than one hotel name (column A) Master =Staff column where some cells may have an “X” indicating that person is a staff member because not all people on the list are staff (Column B) Master = Total number of nights (Column AD) Indv. Hotel Summary = specific Hotel name (this can change) Cell A1 Indv. Hotel Summary =Staff Nights Cell E5 I need the formula to check Master column A and IF it has the same hotel name as Indv. Hotel Summary cell A1, then go back to Master and check that it also satisfies the criteria where there is an “X” in the staff column B and Master column AD and count that number of nights (but only if there was an “X” in column B) – put that calculated total on the Indv. Hotel Summary in Cell E5
Solved by A. E. in 13 mins
I need to add a new column following each time "Total_Billed" appears in the first row. The new column needs to be named "Store Ref" and the 4 digit number that appears in each of the 3 column headers that appear to the left of the new column needs to be filled into the new column up until the last active row. This needs to be dynamic as the size will change with different files. Then the first 3 rows need to be appended 21 times (not including the column headers). Each set of count, applied amount, total billed, store ref need to be appended to the first set (not including the column headers). When it is finished the final product will have a total of 7 columns. It will have 20*20 = 400 rows + 1 header row. The appending of the columns need to be dynamic as the # of discounts vary frequently. Please take a look at the sample as its much easier to visualize. Basically I need to create a table that has a better format. This needs to be completed with a macro!
Solved by E. S. in 30 mins
Then the first 3 rows need to be appended 21 times (not including the column headers). Each set of count, applied amount, total billed, store ref need to be appended to the next 4 rows (not including the column headers). When it is finished the final product will have a total of 7 columns. It will have 20*20 = 400 rows + 1 header row. The appending of the columns need to be dynamic as the # of rows will vary frequently. this needs to be done using a macro
Solved by C. J. in 18 mins
how i can use the =SUMIF('1'!A:A,TODAY()+1-2,'1'!B:B) formula and tell them if there is a holiday or weekend don't count it. like Just on Monday, we will receive a amount for Thursday and Friday
Solved by V. C. in 15 mins
Hi there i'm trying to get a count where in a row Column A contains "Yes" and any of Columns B-E contain "Yes" = 1 but if nothing in Columns B-E contain "Yes" = 0
Solved by V. W. in 23 mins
I need to know who to count the number of specified errors tracked on one sheet on another sheet. I am lost as to what formula I would use.
Solved by G. W. in 18 mins
Then the first 3 rows need to be appended 21 times (not including the column headers). Each set of count, applied amount, total billed, store ref need to be appended to the first set (not including the column headers). When it is finished the final product will have a total of 7 columns. It will have 20*20 = 400 rows + 1 header row. The appending of the columns need to be dynamic as the # of discounts vary frequently. Please take a look at the sample as its much easier to visualize. Basically I need to create a table that has a better format. This needs to be completed with a macro!
Solved by Z. U. in 17 mins
Hi. I have prepared a worksheet in which i want to take count of the day the mentioned task started till present date and the count should be updated everyday automatically. How to do it ? Also If the status of that task is marked pending only that should be included in the count column.
Solved by V. J. in 14 mins
In a long list that includes only three names, I need to count how many instances each name appears.
Solved by O. L. in 27 mins
I have a spread sheet with 4 rows and 4 sections in columns. I am trying to count how many times each name occur in each section together. So how many times does name 1 and name 2 occur in a section how many times does name 3 and name 4 in a section and so on. I would like to then show the results in a table I can send a copy of the table to make it easier.
Solved by K. L. in 30 mins