Count a number of word occurrences based on "Y"

[Zoen]

Hi All You Smarter People Than Me,
I have been trying to work this out, but seem to find examples online only of solutions that are only numbers based.
Currently I have been able to set up my spreadsheet so that it does a basic countif", but what I am having trouble with is adding an extra condition. Only count items with the term"generic" if the column A has a "Y".

I am trying to set the formula up under cell F2. As a summary this is my argument that I want it to provide the answer to:

If cells in A2:A9 have a Y (or happy to write Yes in full), and also have the word "generic" in column C2:C9 then count it towards the number displayed in F2.

Thank you so much in advance

 

[Peter_SSs]

Things to consider for the future:

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

See if this helps

=COUNTIFS(A$2:A$9,"Y",C$2:C$9,D2)

 

[Zoen]

Thanks mate, I will check my account details now. Oddly, I downloaded the zip file for the XL2BB Add in and double clicked it but nothing happened?! That's why I put the picture up! Thank you very much for your time and help, I sincerely appreciate it!

 

[Peter_SSs]

I downloaded the zip file for the XL2BB Add in and double clicked it but nothing happened?!

Double-clicking it is not exactly what is required. See if this helps: XL2BB not on add-in list

 

[Zoen]

ok great thank you, I will check it out. Just to confirm, that formula worked perfectly, but I am sure you knew it would

 

[Zoen]

Double-clicking it is not exactly what is required. See if this helps: XL2BB not on add-in list

Thank you, I have had success with this too!

 

[Peter_SSs]

..that formula worked perfectly, but I am sure you knew it would

It is nice to have the result confirmed since it is not uncommon that the OP actually has different data to what helpers have used (why XL2BB is useful) or the problem is not described accurately. ?

In any case I am glad it worked for you.