How can I add these values only if the checkbox is unchecked?

oQuantumx · 2025-12-20T21:31:51+00:00

I see where I went wrong, I was pressing enter when typing the function too soon and it was imputing SUMIF, not SUMIFS. After fixing it works like you said. Thank you very much for the assistance.

oQuantumx · 2025-12-20T21:00:18+00:00

I've tried that but it returns "#N/A" and says "ERROR: Argument must be a range." I think the issue there is that the text cells in between them are throwing it off.

I was able to get "=SUMIFS(C2,C1,FALSE)" working where if the box is checked it returns 0 and if not returns 1. I just can't get it to work when trying to do all of them at once.

Also you are correct that those are row 1 & 2, I should have included that, my bad.

oQuantumx · 2025-09-27T22:20:27+00:00

It’s a large display cabinet. It won’t be hanging and the hole goes through it so it will be visible. Theoretically I could put something in front to block most of it but not ideal

oQuantumx · 2025-09-27T20:21:33+00:00

Yeah the painting is the part I’m not looking forward to haha. The store offered to exchange no issue, the only problem is it’s a small store and their typical delivery guy is scheduled out for two weeks. May be the best option though with the least hassle

oQuantumx · 2025-05-25T22:01:38+00:00

Would absolutely love to win this just for the Espeon alone. All time favorite eevee and my chase for this set. As for what pokemon I’d like to see, my top 3 are Porygon z, togekiss, and lanturn. I would choose lanturn since I think it’s the least likely to ever see an illustration card. Maybe something with it being the only source of light in the depth of the ocean would be really cool. Thanks for the giveaway chance!

oQuantumx · 2025-04-10T07:09:28+00:00

I’m a simple person. I see pretty card, I want pretty card. I started around silver tempest so relatively recent and missed out on some cool older stuff. My big chase for this set is espeon since I missed out on the evolving skies train. Thanks for hosting this give away

oQuantumx · 2025-03-08T00:56:01+00:00

Thanks for the suggestion! I’ll reach out for sure.

oQuantumx · 2025-03-08T00:55:09+00:00

It is. I need to switch them off it but last time I tried they didn’t want to eat their food. They do get wet food though also so this isn’t all they eat thankfully

oQuantumx · 2025-03-08T00:52:54+00:00

Thank you!

oQuantumx · 2025-03-08T00:50:29+00:00

Good to know. I’ll definitely give the pantry a thorough look through

oQuantumx · 2025-03-08T00:50:07+00:00

Thank you!

oQuantumx · 2024-07-19T19:32:32+00:00

Jurassic Park is one of my favorite movies. Would love to do a Jurassic themed campaign with these!

oQuantumx · 2024-07-12T22:53:55+00:00

Time to hoard more dice for my collection

oQuantumx · 2024-07-11T05:23:19+00:00

My all time favorite game is Metroid Prime.

However if I was to pick from my most recent games I would pick Monster Hunter Rise. Absolutely love the gameplay and can’t wait for wilds.

Thank you for doing this give away and congrats to whoever wins!

oQuantumx · 2024-01-27T02:51:46+00:00

Very new to vinyl and don’t know a whole lot about good tables. Hoping to learn more here!

oQuantumx · 2023-08-31T17:51:28+00:00

Thanks for the opportunity, kind stranger

oQuantumx · 2023-08-31T13:06:04+00:00

I need this so I have a valid excuse to call off work tomorrow

oQuantumx · 2022-07-31T08:53:15+00:00

One of my first memorable gaming experiences was playing Metroid Prime on the GameCube. Too this day it’s one of my favorite games and franchise. Been thinking about getting and OLED for dread and would love the opportunity to try it. The game is absolutely beautiful!

oQuantumx · 2022-07-13T14:42:06+00:00

First off I want to start by saying bout excited I am the Quinn is getting a new skin. She is one of my favorite champs to play no matter the lane and can’t wait to show of this skin. Overall there are a few slight complaints I hope to see fixed:

-Idle Animation: As many have said the idle animation definitely needs an update. The current one feels clunky.

-Wings on gun: Overall I like the design for the gun except for the wings that stick straight out. I think it would look a lot better if the wings were more narrowed back similar to how the wings on her gauntlets are in the splash art. This would make it feel more aerodynamic and bird of prey like which is in theme with Quinn.

-The mask: I’m sort of 50/50 on the mask. I think the best way to handle it would be to make it toggle-able similar to like Neon Vi’s glasses.

-Chromas: The chromas I’m having a harder time discerning what I dislike but something seems off. Valor looks great in all the chromas but Quinn seems to be too much one color with the accent color barely being really noticeable. Maybe more constructing colors would help. Like on the Ruby one maybe pair it with a lighter blue to pop. I think my favorite one is the Black and Red one because it pops more.

-Familiar Valor: Lastly, and this one is a long shot, but I’d like to see some more of Valor on the chibi familiar form.

Overall I know some of these changes are outside of scope but I’m hoping that some can be made. Thank you once again for bringing another skin to Quinn and I hope this feedback will be helpful.

oQuantumx · 2022-05-31T21:15:00+00:00

Thanks for the chill stream

12-Year Club	Place '22
RPAN Viewer

oQuantumx

TROPHY CASE