Countif

[JimmieNeu]

This is the formula I am using:

=IF(SUMPRODUCT(COUNTIF(C4:C8,{"Left Square Arm Combo";"Right Square Arm Combo";"2 Square Arm Combo";"2 Arm Left Radius Combo";"2 Arm Right Radius Combo";"10.5 Armed Right Radius";"10.5 Armed Left Radius";"9.5 Armed Right Radius";"9.5 Armed Left Radius"}))=0,"",SUMPRODUCT(COUNTIF(C4:C8,{"Left Square Arm Combo";"Right Square Arm Combo";"2 Square Arm Combo";"2 Arm Left Radius Combo";"2 Arm Right Radius Combo";"10.5 Armed Right Radius";"10.5 Armed Left Radius";"9.5 Armed Right Radius";"9.5 Armed Left Radius"})))

All of the descriptions between the quotations equals 1 count. Except for "2 Square Arm Combo". I need that one to count as 2. How is this possible?


Thank you in advance for your time!

 

[Phuoc]

=IF(SUMPRODUCT(COUNTIF(C4:C8,{"Left Square Arm Combo";"Right Square Arm Combo";"2 Square Arm Combo";"2 Square Arm Combo";"2 Arm Left Radius Combo";"2 Arm Right Radius Combo";"10.5 Armed Right Radius";"10.5 Armed Left Radius";"9.5 Armed Right Radius";"9.5 Armed Left Radius"}))=0,"",SUMPRODUCT(COUNTIF(C4:C8,{"Left Square Arm Combo";"Right Square Arm Combo";"2 Square Arm Combo";"2 Square Arm Combo";"2 Arm Left Radius Combo";"2 Arm Right Radius Combo";"10.5 Armed Right Radius";"10.5 Armed Left Radius";"9.5 Armed Right Radius";"9.5 Armed Left Radius"})))

Or:

=IFERROR(1/(1/SUMPRODUCT(COUNTIF(C4:C8,{"Left Square Arm Combo";"Right Square Arm Combo";"2 Square Arm Combo";"2 Square Arm Combo";"2 Arm Left Radius Combo";"2 Arm Right Radius Combo";"10.5 Armed Right Radius";"10.5 Armed Left Radius";"9.5 Armed Right Radius";"9.5 Armed Left Radius"})));"")

 

[JimmieNeu]

Yup!
I just figured that out... lol


THANKS!!

 

[superfb]

Randomly, what is the significance of adding 1/ in a formula?

 

[JimmieNeu]

All of the items within the quotations take 1 square arm to complete except for the 2 square arm item. I am using the formula to auto populate a cell with a square arm count.