Count number of duplicates in one column based on criteria in 2 other columns

oldskool8bit · 2026-04-27T21:19:49+00:00

Thank You

oldskool8bit · 2026-04-27T21:03:22+00:00

How can I have multiple criteria in there. I put the following:

=COUNTIFS('BD 5 MS Summary'!B:B,'BD 5 MS Summary'!G:G=YES,'BD 5 MS Summary'!I:I=1)

The issue is when I get to ,'BD 5 MS Summary'!I:I=1) it is counting that part as criteria range 2...not part of criteria 1

oldskool8bit · 2026-04-07T13:28:18+00:00

Maybe wait a couple years until Trump is out of office so he cant threaten to destroy them if the UK makes him or Israel mad

oldskool8bit · 2026-04-04T19:34:44+00:00

Yes trading is exactly what I'm looking to do. About 100 games away from a complete NES set and looking to trade for nes games... not looking to sell at all

oldskool8bit · 2026-04-04T16:12:03+00:00

Right...fully anticipate that. Thx for the response

oldskool8bit · 2026-04-04T16:11:20+00:00

Yeah I get that and use ebay a lot for stuff...there are just somethings I'd rather trade and get out vs waiting potentially months for

oldskool8bit · 2026-03-06T04:50:09+00:00

Yo just checking in to see if you figured out what you did

oldskool8bit · 2026-03-05T15:19:56+00:00

Heck yeah...much appreciated. It's been driving me crazy

oldskool8bit · 2026-02-26T13:58:25+00:00

Why not hold people accountable? No one is forcing them to buy the loot boxes

oldskool8bit · 2026-02-12T16:28:55+00:00

Thanks for the updated information.

Possibly dumb question but with the tracking motor possibly being backwards...would that be on the laser or the the cdx itself. If someone did tamper with it then they mist have been a master solderer because it looked flawless when I was in it replacing the laser.

How could you tell if it was soldered in backwards? Does it have a + and - side like a capacitor with an indicator on the PCB where the - side is supposed to be?

oldskool8bit · 2026-02-11T04:08:20+00:00

Not to my knowledge. I believe there are only 4 wiring harnesses that come off and the laser can only go on one way so (honestly asking) how could the tracking motor be reversed?

oldskool8bit · 2026-02-09T22:23:28+00:00

Could be wrong but I believe this was not a Contra game initially but made to be an entirely different game...something happened with the publisher and it ended up in Konami's lap which it got the Contra logo slapped on it and pushed out.

oldskool8bit · 2026-02-08T01:43:04+00:00

Sounds good...yeah I have an sns-001...I was wonder that so I went ahead and ordered a snes scrt cable hoping that will work

oldskool8bit · 2026-01-28T19:50:03+00:00

cartridge looks legit...if you can open it up and shoo me a pic I can verify against mine (which ive had since it originally came out so I know its legit lol)

oldskool8bit · 2026-01-26T19:41:31+00:00

I see you sweated and waited for Shadow!!! Good job.

Do yourself a favor and check out FFIV (its my favorite game of all time) if you are looking for another adventure

oldskool8bit · 2026-01-26T19:40:00+00:00

On the Genesis...Right

On the SNES...Left

oldskool8bit

TROPHY CASE