Count 2 different variables from different columns?

[willbassyeah]

Hi i read some of the post and people recommend the use of sumproduct, however, i cant seem to get the formula right.
My file will be like this:
excel testing1.xlsx

I need to count the number of gibson and high quality at the different column.
Regards, any help is appreciated

[FDibbins]

have you tried using the countifS() function for this?

[MarvinP]

Hi willbassyeah,

See if this answer isn't what you want with no formulas needed.

[willbassyeah]

Hi Marvin the problem is i cant combine the column for this, and Fdibbins nope, i have not try countifs, i tried countif though. will try again. regards

[willbassyeah]

Hi guys i found it, i am able to use countifs for this, just for reference for anyone who view the thread:
=countifs(criteria_range1, criteria1, criteria_range2, criteria2)+(criteria_range1, criteria1, criteria_range2, criteria2)

here is the formula that i use for my testing file
:=COUNTIFS(A:A,"*gibson*",B:B,"*high quality*")+COUNTIFS(C:C,"*gibson*",D:D,"*high quality*")+COUNTIFS(E:E,"*gibson*",F:F,"*High quality*")

[Cutter]

@ willbassyeah

Welcome to the forum.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[willbassyeah]

Hi cutter thanks for reminding, will closed it when i am satisfied with the answer,
Regards
William

[gablack]

I am trying to use the countifs function to count the number of accidents by accident type for each year. The problem I have is that some people have had more than one accident type and they are within one cell. I know I could separate the text by text to columns but I really would like to keep the format as is. I've attached a worksheet of what I'm trying to do. Is this possible?

[Cutter]

Hello gablack, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.