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!”
Here are some problems that our users have asked and received explanations on
I have a formula "=COUNTIFS(D2:D1000,">=11/1/2018",D2:D1000,"<=11/30/2018")"
I use this to count dates of interviews. One problem I'm having is that as I finish an interview I move the row to another excel page and delete it from the page it was on. As I delete rows the range of my formula gets smaller. After a month of adding and moving rows, the formula range decreases to around D2:D55. How can I make my formula stay D2:D1000 even when I delete rows within that range?
Solved by B. Y. in 14 mins
I have a condition where the results of the excel (if and) formula count are negative and logically if the result is negative then zero (0)
example: in the AA column the formula is
= IF (AND (N19> K19, N19> AB19), Z19 * 1, N19-K19)
if AA19 <0 (negative) then the result is 0 or AA19 * 1
how about the excel formula for the condition? thank you
Solved by M. S. in 16 mins
counting numbers in one column always count from the last number wait until we have a match a match is
maximum 5 numbers with 2 reps and 3 numbers with minima 3reps
Solved by F. W. in 30 mins
I have a problem regarding to How to use COUNTIF function to make count of cells in excel between two numbers
Solved by O. C. in 13 mins
How can I count the number of entries in a sheet dependent on the date that it has been entered.
Solved by I. A. in 21 mins
Require macro to clean up data, display count of recurrences and graphical outputs
Solved by I. C. in 28 mins
Need to clean data set, have counting sheet to display count of reasons by user along way to ensure it is repeatable
Solved by S. J. in 27 mins
Trying to count and chart how many inventory lots were available on any given date. Question Example: For 9/1/2013 - how many lots were available?
Each lot has a "Release Date" and "Expiration Date" and is "Available" every day from the "Release Date" to and including the "Expiration Date". Example: 134530-001 was available every day from 8/8/2013 (day after the "Release Date) and 8/18/2013.
Data available is: Lot number (Column A), release date (Column B), expiration date (Column C).
Solved by C. J. in 16 mins
Hi, I need to count how many suppliers (which can be repetitive in a row. e.g. (A2:A16452) that has costing value (in another row e.g. D2:D16452) above or equal to a particular value.
Solved by V. U. in 25 mins
Solve an average size - want to look at name on tab QScorecard B3, then look at the data tab - needs to sumifs ( new/existing business) column C, and Column D = Closed won and return ($$$$) then also countifs same criteria but solve ($$$$)/ count to give us the Average size
Solved by F. E. in 11 mins