Get instant live Excel expert help with a COUNTIF Functions

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.

i have a count if problem =IF(COUNTIF(BH3:BL3,FALSE),"FALSE","TRUE")

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%)

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.

(=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

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))),"")

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.

Hello, I am trying to do a countif with or a subtotal, can you help please?

My countif formula is calculating hidden cells to, I want to ignore hidden rows. Is there a way?

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)