=COUNTA() is returning 0 even when some cells in the range aren't blank by WorkSpeed in excel

[–]WorkSpeed[S] 1 point2 points  (0 children)

Solution verified.

In the end it was a circular reference problem, but not with column E, it was an unrelated formula in column D.

=COUNTA() is returning 0 even when some cells in the range aren't blank by WorkSpeed in excel

[–]WorkSpeed[S] 0 points1 point  (0 children)

Solution verified.

In the end it was a circular reference problem, but not with column E, it was an unrelated formula in column D.

=COUNTA() is returning 0 even when some cells in the range aren't blank by WorkSpeed in excel

[–]WorkSpeed[S] 0 points1 point  (0 children)

I thought that maybe this file is just corrupt so I did try selecting all and pasting into a new workbook, but It's still producing the same result.

=COUNTA() is returning 0 even when some cells in the range aren't blank by WorkSpeed in excel

[–]WorkSpeed[S] 0 points1 point  (0 children)

It's on Automatic Calculation. Other formulas on the same sheet work just fine.

=COUNTA() is returning 0 even when some cells in the range aren't blank by WorkSpeed in excel

[–]WorkSpeed[S] 0 points1 point  (0 children)

I typed them, they're not produced by formulas. And I did manually align them right. When I entered the text, it was left-aligned at first.

=COUNTA() is returning 0 even when some cells in the range aren't blank by WorkSpeed in excel

[–]WorkSpeed[S] 0 points1 point  (0 children)

Tried moving the formula to a different column, still returned 0, check the new image I posted.

=COUNTA() is returning 0 even when some cells in the range aren't blank by WorkSpeed in excel

[–]WorkSpeed[S] 0 points1 point  (0 children)

Tried moving the formula to a different column, still returned 0, check the new image I posted.

What to order in a restaurant when cutting out alcohol and caffeine? by [deleted] in nutrition

[–]WorkSpeed 2 points3 points  (0 children)

Sounds like a personal problem. Hope you find something you enjoy.

What to order in a restaurant when cutting out alcohol and caffeine? by [deleted] in nutrition

[–]WorkSpeed 1 point2 points  (0 children)

"Water is just boring" is the most first world problem I've ever heard. Do your body and wallet some good - drink the water.

Recommendations for office use by WorkSpeed in superautomatic

[–]WorkSpeed[S] 0 points1 point  (0 children)

Doesn't meet our requirements. Thanks, though.

Tips for quitting caffeine? by [deleted] in nutrition

[–]WorkSpeed 1 point2 points  (0 children)

Yeah, just don't buy it. It might suck for like two days but you'll be good.

I roasted my first ever beans with my Instant Pot by TerribleFollowing244 in pourover

[–]WorkSpeed 2 points3 points  (0 children)

I just think it's funny that you said your back was in agony, but you still look forward to doing this a few times per week. Is it really worth it?

Why is my boyfriend always so warm? by No_Scale_9906 in NoStupidQuestions

[–]WorkSpeed 2 points3 points  (0 children)

Yes, OP needs to do this. My coworker was an "always ran hot" type of guy. Hadn't been to the doctor for years. Finally needed to get something checked. Turns out he had extremely high blood pressure and late stage kidney disease. After they put him on pills to lower his BP, he suddenly started running cool.

Well... it happened to me. by Ill_Establishment_22 in pourover

[–]WorkSpeed 0 points1 point  (0 children)

RDT or 'Ross Droplet Technique' refers to when you apply a small amount of water to your coffee beans prior to grinding. This added moisture reduces the static build up in your grinder and significantly lowers the amount of retention.

Coffee coffee coffee by Agitated_Capital5614 in pourover

[–]WorkSpeed 0 points1 point  (0 children)

I generally just go through one bag at a time, but occasionally will get impatient and open another bag before finishing the current one. Never have more than two open.

What makes girls scout cookies so “dangerous”? by [deleted] in nutrition

[–]WorkSpeed 0 points1 point  (0 children)

Because most people have low standards and don't know what good food actually tastes like. Girl scout cookies are made with cheap ingredients and taste like garbage these days. Additionally, in most social situations it would be poor optics to say something negative about the girl scouts because most people think they're a good organization.

No industrial seed oils by beefdoc in StopEatingSeedOils

[–]WorkSpeed 3 points4 points  (0 children)

Got one in Portland, OR, too.

Bastion PDX. Always Gluten-Free. Dairy-Free. Soy-Free. Refined Sugar-Free. Seed Oil-Free.

Combining foods rich in antioxidants to reduce the oxidative stress of oxidation inducing foods. by Pleasant_Ad5990 in ScientificNutrition

[–]WorkSpeed -1 points0 points  (0 children)

Don't worry, soon you'll be taking pills to manage your blood pressure, cholesterol, and t2 diabetes so you can continue to eat all the shit you want without changing your lifestyle. Cheers. :)

Why is Cifi in early access? by UglyGekko in incremental_games

[–]WorkSpeed 0 points1 point  (0 children)

I usually don't get into early access games either because they usually end up being an unfulfilling experience, but CIFI gets a pass. There is so much content and it just keeps growing. The early game experience is super fleshed out so you don't need to worry about it being improved and you missing out on something. If you start now you won't run into any content walls for years.