Count ifs?>

Juan Antonio Tena

Hello,

I created a form and now have all the data i need. However My formula to give me the number of each tea that was voted for has to be accounted for. It seems that my countif formulas are not working correctly. Can anyone help me?

Mike Wilday

Can you please share the formula you are using? 

Juan Antonio Tena

I have tried a couple different ones

 

=COUNTIFS([Favorite #1]1:[Favorite #2]52<bigelow: earl grey)

 

=SUMIF([Favorite #1]1:[If I had to choose a green tea, I'd pick:]52, yamamoto: genmai, [sum_range])

Mike Wilday

=COUNTIFS([Favorite #1]1:[If I had to choose a green tea, I'd pick:]52, "yamamoto: genmai")

Try that one? It will give you a 1 for every time Yammamoto: genmai appears in the range that you suggested. Because you're looking for that text specifically you have to put it in quotes. 

Juan Antonio Tena

Mike,

 

No matter the name I give it or specify the value comes back at zero

Mike Wilday

Are you putting the Countif formula on the same sheet or trying to pull it from a different sheet? 

Create a new row at the top and put this in the first Cell... 

=Countifs([Favorite #1]:[Favorite #1], "Bigelow: Earl Grey")

Does that return a count? 

Juan Antonio Tena

Hello Mike,

 

thank you for helping me, but even when I followed your instructions to a T I now get #BLOCKED. very puzzling to say the least.

Mike Wilday

Hi Juan, 

You get #blocked because one of your cells you are referencing might contain an error. Make sure you don't have a formula that is not working in the Favorite column. 

https://help.smartsheet.com/articles/2476176-formula-error-messages#blocked

Juan Antonio Tena

wow, 

 

thanks Mike!

Mike Wilday

Did that do the trick for you? Glad I could help you out. 

Juan Antonio Tena

Yes Mike, thank you for being so patient. 

Mike Wilday

I'd like to thank Smartsheets for developing that patience in me.  You're welcome!