 # 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 data set with values next to a variety of "Care types" listed on various sheets. I want to do a cumulative count of the sum of the values next to each specified phrase. I tried a SUMPRODUCT feature but it did not work. I also tried COUNTIF.
Solved by E. J. in 19 mins
i have a count if problem =IF(COUNTIF(BH3:BL3,FALSE),"FALSE","TRUE")
Solved by B. Q. in 14 mins
I have a total score being calculated based on 5 options under 9 categories (below is the formula). I need to make add a 50% weighting to the first category and then evenly distribute to the remaining 8. Does anyone have the slightest idea how this can be accomplished? =SUM(COUNTIF(I3:Q3,{"Needs Development","Basic","Intermediate","Advanced","Expert"})*{1,2,3,4,5}) Talent Multiplier (50%) Purpose Driven (6.25%) Principled Agility (6.25%) Results Oriented (6.25%) Strategic Orientation (6.25%) Innovation (6.25%) Collaborative Relationships (6.25%) Risk Mitigation (6.25%) Change Champion (6.25%)
Solved by O. Y. in 24 mins
I am trying to count the number of times a particular word shows up in a column. BUT, I have all these words listed under different categories. So I can filter the results by categories and use a CountIf function, but I'm not sure if it's also counting the times the word shows up under other categories because the range listed in the formula might still include the others.
Solved by T. Q. in 27 mins
(=SUM(IF(COUNTIF(\$C\$3:\$F\$3,ROW(\$1:\$6))>COUNTIF(\$C5:\$F5,ROW(\$1:\$6)),COUNTIF(\$C5:\$F5,ROW(\$1:\$6)),COUNTIF(\$C\$3:\$F\$3,ROW(\$1:\$6))))-G5) I'm trying to create a mastermind game solver. The above formula only works with numbers, not colours. I want to tell me how many colours are in the wrong spot. Example: Code: Black - White - Green - Yellow Guess: Blue - Purple - Yellow - Green = 2 Whites
Solved by X. D. in 24 mins
need to correct the formula =IF(COUNTIF(\$F9:K9,">0")<\$E9,IF(AND(IF(AND(MONTH(\$B9)=MONTH(K\$3),YEAR(K\$3)=YEAR(\$B9)),\$A9/\$E9,IF(SUM(\$F9:K9)=\$A9," ",K9))<>" ",IF(AND(MONTH(\$B9)=MONTH(K\$3),YEAR(K\$3)=YEAR(\$B9)),\$A9/\$E9,IF(SUM(\$F9:K9)=\$A9," ",K9))<>0),IF(K\$2<>"",K\$2*\$A9,0),IF(AND(MONTH(\$B9)=MONTH(K\$3),YEAR(K\$3)=YEAR(\$B9)),\$A9/\$E9,IF(SUM(\$F9:K9)=\$A9,"",B9,K9))),"")
Solved by C. J. in 30 mins
Hi, I have an excel formula that I have put together but the issue I am having is that the formula runs too slow. The purpose of this document is for the user to create an ongoing list of company names which will have duplicates. The on a separate sheet, it needs to extract only the unique company names from the original list. This would be a working list so this needs to update as company names are being inputted within the 1st sheet. I have a formula that works correctly, but the problem that is that it slows down the document to the point the document can't be used. The document is calculating the formula each time which is causing the slowness. Does anyone have a solution for this? Here is the formula I am using: =IFERROR(INDEX(TableName,MATCH(0,INDEX(COUNTIF(\$A\$1:A1,TableName),),0)),"") I hope this makes sense. Any help would be appreciated.
Solved by G. S. in 14 mins
Hello, I am trying to do a countif with or a subtotal, can you help please?
Solved by V. D. in 24 mins
My countif formula is calculating hidden cells to, I want to ignore hidden rows. Is there a way?
Solved by T. A. in 22 mins
i need to add a excel max function to change the following formula to output "0" if the result is a negative number. Any ideas? (fyi this is a google sheets formulas, not written in excel) =ARRAY_CONSTRAIN(ARRAYFORMULA(IFERROR(IF(COUNTIF('Battle Points'!\$F\$2:\$F\$81,\$L25),\$M25-INDEX('Battle Points'!\$K\$2:\$K\$81, MATCH(\$L25,'Battle Points'!\$F\$2:\$F\$81,0)),"No Data"),"No Data")), 1, 1)
Solved by K. E. in 22 mins