Get instant live Excel expert help with a COUNTIF Functions

“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 have a table that lists data by date and time (in separate columns) I am able trying to extract the data using countifs date range to auto populate other tables containing overviews by week and month. I can get the data via date easily, however I now need to count data between two times (06:00 - 18:00) on a specific date or date range.
Solved by F. H. in 12 mins
I need help with a Countifs formula. I need help soon please
Solved by A. E. in 21 mins
I need a formula that counts the number of times that column B prints "D", column C prints either ShotGoal or 8MGoal, and column F prints "Eighth" in Excel. I have gotten this correct for when column F is "First" through "Seventh". What is correct about my first expression but incorrect for my second? I keep getting zero when I know that output is false. This is happening for many expressions containing "Eighth" See the expressions below. =SUM(COUNTIFS(B2:B300, "D", C2:C300, {"ShotGoal","8MGoal"}, F2:F300, "Seventh")) =SUM(COUNTIFS(B2:B300, "D", C2:C300, {"ShotGoal","8MGoal"}, F2:F300, "Eighth"))
Solved by D. H. in 29 mins
Hi I need to know the formula to use countifs and return a value when the data in first sheet is in column and the second one in row
Solved by O. A. in 12 mins
how can i turn my sumifs into a countifs because my sumifs works great and i also want to count the thing im summing
Solved by O. C. in 13 mins
i have a very long countifs formula thati want someone to look atand tell me if the punctuation is right
Solved by A. C. in 11 mins
I am analyzing a data sheet with multiple columns. Is there a way to highlight certain rows of the data sheet that follows a certain criteria. That criteria is machining a COUNTIFS formula,I cannot find out how to do this?
Solved by M. A. in 30 mins
I need a formula for a multi workbook that countif date range on workbook 4 the date range in column A is between 1/1/2018 and 3/31/2018 and the entry in column B is Medical then L32 on workbook 1 (medical column) would would count 1. I would need them to count all of the "medicals" in column B for the date range above.
Solved by G. H. in 21 mins
My formula I am creating is using AND logic with multiple criteria and multiple columns and then dividing it by a COUNTA formula that gives a certain number. I seem to be having problems with the AND logic using countif multiple criteria and also trying SUM(IF()).
Solved by E. B. in 28 mins
I want to multiply a countifs function by another column in the same row
Solved by S. Y. in 14 mins