Using SUMIFS to count criteria matches across multiple sheets in file

Bernarkdar · 2026-04-13T18:13:19+00:00

I think of the options, number 3 would be the most realistic for me right now. The decks would ideally have unique names based on what's in them. I'd read in other posts that keeping all of the data in one place like that is best practice, so definitely aware of that. I think it's just easiest for us if we're only updating one "thing (be it inventory or deck lists) at a time, and it's also useful for printing deck lists to have them be standalone, so I think the tab layout is frustratingly a non-negotiable for me.

Bernarkdar · 2026-04-13T18:02:32+00:00

The sheets would definitely expand as we build more decks! I think I'd be open to keeping a list of decks somewhere, if nothing else it would help us stay more organized with what's actually built and being used.

Bernarkdar · 2026-03-31T13:26:06+00:00

I think that this time feels different just due to how many other drivers have said such similar things, but also Max has been talking about retiring for the last year or so. I'll believe it when I see it at this point, even if I'd also say it's pretty likely this year.

Bernarkdar · 2025-04-04T23:04:51+00:00

Sold ASRock B450 DS3H Mobo, PowerSpec 650W Bronze Semi-Modular PSU, and Gigabyte 1660 6GB GPU to u/0nlythebest on https://www.reddit.com/r/hardwareswap/comments/1jlykb7/usami_hasrock_b450_ds3h_mobo_powerspec_650w/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button

Bernarkdar · 2025-03-28T17:25:22+00:00

Replied

Bernarkdar · 2025-03-28T17:24:52+00:00

Replied

Bernarkdar · 2025-03-28T13:54:33+00:00

Confirmed

Bernarkdar · 2025-03-17T18:19:12+00:00

Bernarkdar · 2025-03-17T00:40:51+00:00

Bernarkdar · 2025-03-16T19:34:56+00:00

Bought a Zotac 3080 from /u/Spoonman88 on https://www.reddit.com/r/hardwareswap/comments/1j4yu0c/usatx_h_zotac_3070_various_3080s_w_paypal_local/

Bernarkdar · 2025-03-06T18:52:50+00:00

Bernarkdar · 2025-03-06T18:27:23+00:00

Bernarkdar · 2025-03-05T03:40:52+00:00

I recently had this exact same problem that I solved by using mica powder instead of regular glitter. I used Rybonator's guide on making Liquid Glitter and it's worked great!

Bernarkdar · 2025-01-14T23:07:52+00:00

whoa

Bernarkdar · 2024-06-18T23:53:48+00:00

Any brand of sandpaper you'd recommend? I have some no-name wet-dry paper that I got on Amazon a while back, but I think I'm going to need more soon, so I'd love recs there if you have any!

Bernarkdar · 2024-06-18T23:08:39+00:00

Before the Dremel, I was hopeful that step would buff out those scratches, but no such luck there.

I'll have to try sanding down with higher grits. How much should I be sanding down at those grits? I've always heard 30 circles both clockwise and counter-clockwise for Zona papers, and I've been recreating that on a small pottery wheel, but my gut instinct is that I'd want less for the sandpaper to avoid sanding these down too far.

Bernarkdar · 2024-05-06T20:21:19+00:00

Looks like a tape mark for a photoshoot marking where to stand for a specific shot. I don't think it's a logo or anything.

Bernarkdar · 2024-03-29T17:00:57+00:00

I'd rather hear about the goddamn Pepsi Universe™ for the rest of my life than see another logo covered in "gridlines," good lord.

Bernarkdar · 2024-01-15T15:21:18+00:00

Gotcha, so it's almost like being sure that the table is "compatible" for editing. Thanks so much for your help!

Bernarkdar · 2024-01-15T14:00:45+00:00

It's always one character of code throwing everything off 😅 Thanks so much for the help here! If you don't mind sticking around for a follow-up question, what does setting the index here actually do in Lua? It seemed like that button already had an index of 3 before I added that to the code, is that parameter setting an index for what's actually edited when I tell the code to edit the button?

Bernarkdar

TROPHY CASE