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

Hi, I have 1 spreadsheet with two tabs. On my first sheet I have on hand inventory consisting of an item description and on hand count taken from a few days ago. On my 2nd sheet I have the same item description and a count that was sold. I am trying to create a vlookup on my 1st page to look at the item description and if that appears in Column H:H then to take the number corresponding to the sold item and place it on the first page in a new column next to the old item count. Hope this makes sense...
Solved by O. B. in 11 mins
hello i need help to count comma separated values by cell in multiple cells e.g first cell has 14,0,4 second cell has 4,2,0 etc. the first value in the cells need to be added up i.e 14+4 =18 and displayed in a cell named regular hours the second values need to be added up and displayed in another cell called O.T single=0+2=2 and the third values need to be added up and displayed in another cell called O.T 1/2=4+0=4
Solved by E. W. in 12 mins
I want to use a macro to pull some data from the internet I currently have company numbers, i can then put the company numbers into a web address to return a table on a webpage, I then want to put that data on the next cell the web page looks like www.website.com/companynumber the website then shows the turnover and employee count, i want to put the turnover in one column and the employee count in another column
Solved by V. Y. in 19 mins
Count initials in an array. not sure how to do this but I want to get numbers for each set of intials.
Solved by X. Q. in 21 mins
I am trying to insert a formula that will count the blank fields so I don't have to put a number in the fields ex. =COUNTIF(B3:B10, ). Is this possible or do I have to put in a number? If not a number can I put in a special character? I need something that can be spotted easily. My other values have all numbers. I am not very good with excel spreadsheets.
Solved by I. C. in 21 mins
HI I CREATED A SHEET THAT CONTAINS A MASTER LIST OF ITEMS AND CODES THAT ARE USED TO TYPE ORDERS, THERE IS A FINAL LIST THAT WILL COLLECT ALL DATA FROM EACH ORDER TO DETERMINE FINAL COUNT OF ALL ORDERS, BUT I CANT GE IT TO RECONCILITAE IN THAT FINAL SHEET, THERE IS WHERE I NEED HELP..PLEASE..
Solved by D. Q. in 30 mins
Display the total for the quanitity column and remove the count from the state column.
Solved by C. W. in 13 mins
need chart on DFW Client count tab colum H-I-J row 57 thru 64
Solved by X. L. in 22 mins
I have two columns, x and y coordinates. I want to create a third column to see how many of each x, y coordinates match. so if there is a (100, 100), I want to count how many of those exist in the data set.
Solved by F. S. in 29 mins
I need a formula that will count the number of text events in tab 1, column BN, between two dates (j field to the right vs. tab 1, column E). I cannot get the countifs function to work...
Solved by E. H. in 20 mins