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 need help with COUNTIFS formulas. Expert required only
Solved by V. J. in 19 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
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
hello I keep getting " this formula is wrong " message whenever I'm trying to write COUNTIFS , and I'm sure I'm writing the write formula
Solved by S. W. in 17 mins
I need help creating the output for a table. I believe I can use a ISNUMBER(SEARCH()) or COUNTIFS() formula but I am not sure
Solved by G. H. in 11 mins
I need a countifs formula for text values that ignores duplicate values but I can attach other countifs criteria to
Solved by F. Q. in 17 mins
I need help with countif google sheets. I need formulas that will dynamically update as new sheets are added to the workbook. I think they will be multi-variable COUNTIFS statements.
Solved by S. S. in 29 mins
I need help creating a COUNTIFS formula that dynamically updates when new sheets are added.
Solved by C. U. in 27 mins
Hi, I'm trying to create a football table that takes the data directly from the scoresheet. Eg Team A beat Team B 3-2. Therefore, I want the table to show Team A have won that game and that Team B have lost it. If they draw, I want it to show that too. I think it's COUNTIFS but I'm not sure how to use it... help please!!!
Solved by B. B. in 25 mins
i am using a countifs formula to find a value that meets the criteria between a date rage and a specific value. however the specific vaue is from another formula =left & =right so it comes back as #value!
Solved by C. E. in 13 mins