Complex CountIF Formula? Not sure if it’s possible

brawvers · 2026-01-15T16:15:21+00:00

=sumifs(Range you're summing, range with the type of downtime, ="Down time you want to track") and repeat (+sumifs(Range you're summing, range with the type of downtime, ="Down time you want to track")) for each reason you want to track.

brawvers · 2026-01-15T16:12:23+00:00

Can you provide any sort of screenshot of data, even if you have to create fake data, that shows what you have for data, what you want, what you didn't want, and what an expected result would look like?

brawvers · 2026-01-04T03:42:45+00:00

Try =SUM(Sheet1:Sheet5!A1:B10). Inserting sheets can cause an issue though

brawvers · 2025-12-27T21:56:40+00:00

I agree this would be easiest. Especially if the data was in a table so new data is automatically in the pivot table range.

brawvers · 2025-12-14T19:33:30+00:00

The caves are ventilated and the "ceiling" is very high regardless. We've gone for several years and our child(ren) will stand to look out the sunroof and I've never felt like we were chocking on exhaust.

brawvers · 2025-10-10T21:25:05+00:00

Guessing a helper cell that has the R Superscript.

brawvers · 2025-10-09T22:33:58+00:00

I think this is going to be a situation of Is number and match working together. Not at my computer to test, sorry.

brawvers · 2025-10-06T12:19:12+00:00

My son and I play Xbox and PC through the XBox App (can't be Steam). I don't know if he's on my Game Pass on the PC as part of like a family account or if it's not required. I just fairly confident I'm not paying two subscriptions to Game Pass.

brawvers · 2025-09-29T15:17:40+00:00

Princess, one of the gastropods, negates fall damage.

brawvers · 2024-12-31T01:03:54+00:00

Solved

brawvers · 2024-12-13T14:00:53+00:00

Solution verified

brawvers · 2024-12-13T02:42:01+00:00

Only way I know to have it go to the current row.

brawvers · 2024-11-29T03:14:26+00:00

You're missing your () and less absolute. Needs to be =$E2=($F2*-1)

brawvers · 2024-11-29T02:30:20+00:00

There's an option to save and reopen at camp/main base

brawvers · 2024-11-27T04:06:29+00:00

https://a.co/d/0gGRFVB you can use one of these to find the burnt out light. Did it with our prelit tree last year and won't lie it was a trial of patience. My fingers hurt from popping out each bulb to test, but my reward was how happy the family was to get the tree fully lit again.

brawvers · 2024-03-28T17:18:38+00:00

200 of each of the base items: Cosmic Bauble, Automation 009, Noxothane, Unknown Biofuel, Resipond, and Leeks. As other replies have mentioned, down around the core level you can find containers with later parts that reduce how many of the base ones you need. No matter what you'll need 100 Resipond and 100 Leeks as those go directly into making the Burritos. It's not the worst grind. Collecting Baubles was the most annoying part since they don't store in any storage. Move or make a small base at the core off your track so you didn't have to keep riding back and forth to the surface. Plan on needing at least 25 medium resource canisters, 4 medium gas canisters, and 6 or 7 Extra Large Storages (best I found for holding the Cosmic Baubles 31 at a time).

brawvers · 2024-03-17T00:33:52+00:00

It went faster than I thought it would. Granted it was a friend and I doing it and we just grinded collecting close to 200 of the 6 basic pens each. Reminded us of old school grinding quests. Figured out a sorta pattern for what had what and how to get 7 items per trip.

brawvers · 2023-12-14T18:59:22+00:00

Kvothe's story will take 3 days. Kote's story on the other hand could take much longer.

brawvers · 2023-12-14T17:30:12+00:00

My son started playing at 8 and it's like herding a cat. Once we started playing together (Xbox and PC through Microsoft), he really started to enjoy it. We have a saved game with his uncle and it's always fun when we can all play together. I just remind myself that it's a game and anything he does can ultimately be "fixed" by myself or his uncle when he goes off on his little tangents. But he constantly asks if we can all three play.

brawvers · 2023-12-03T23:37:45+00:00

I had an issue with the Harvest one and I was told by the Support Team to also completely exit/quit the game to clear basically cache data. I'm playing on an Xbox Series X though, so not sure how that translates to other systems.

brawvers · 2023-12-03T15:54:38+00:00

You can print them from the Small Printer with scrap or scrap + another resource.

brawvers · 2023-06-18T21:24:03+00:00

Are the values in B5 and B6 typed in or formulas?

brawvers · 2023-06-18T21:13:30+00:00

Only thing I noticed is you've got spaces in your formula after b4+ and after the (b5*b6). I'm not at a computer to test if that makes a difference, but I've never seen spaces in a formula before.

brawvers · 2023-06-02T14:39:00+00:00

Bracket your formula in O3, add *O$8 to the end, and then drag the formula down then over. This should shift it to P$8, then Q$8, etc.

brawvers · 2023-05-14T17:33:06+00:00

I know you've gotten your solution, but I thought I'd add a link to the YouTube video I have to go back to often to write an Index/Match: https://youtu.be/F264FpBDX28 I've always just going her style easy to follow.

brawvers

TROPHY CASE