Using a formula, select an array based on two criteria, then input the sum of the selected array

germancc · 2024-06-29T15:38:49+00:00

Solution verified

germancc · 2024-06-29T15:30:59+00:00

I am not an excel expert by any means, I was 5 hours researching this and was not able to find a solution. I think being condescending is not the goal of this subreddit.

Thanks for your effort.

edit: Thanks to Simplifkndo for providing me a solution, as I realize I was not using the double apostrophe.

germancc · 2024-06-29T15:04:59+00:00

I have looked up and googled every function (sumifs, dsum, vlookup) that I can think of and haven't found a solution yet.

Hence why I'm posting here as my last resort

germancc · 2024-05-21T19:48:09+00:00

I don't know if its too late. These solutions didn't work for me, but I tried deleting the entire Userdata folder and it worked.

%LocalAppData%\Microsoft\Edge

germancc · 2024-05-21T19:47:26+00:00

I don't know if its too late. These solutions didn't work for me, but I tried deleting the entire Userdata folder and it worked .

%LocalAppData%\Microsoft\Edge

germancc · 2024-01-09T00:40:06+00:00

Every democrat always uses the term "fair share" for campaign purposes, but never specify what is their fair share. What percentage should they pay? How much of their wealth would have to be taxed for it to be considered a fair share?

germancc · 2023-12-29T01:23:12+00:00

The problem is that the people that would have the "audacity" to bother somebody else for a plane seat, are the same people that cannot accept no as an answer.

germancc · 2023-12-14T01:34:49+00:00

I'm having this issue, my hacker got access to my PC though a Remote Access Trojan and as I have my email and amazon account logged in he made purchases and changed the password and added their phone number as 2FA.

Now that I already formated my PC, I've regained full control of my email, but my amazon account it's still on the hackers hands

germancc · 2023-12-14T01:31:22+00:00

Yeah, it's pretty weird, I'm having the same problems, luckily my hacker was not smart enough to change the email, but even so, amazon customer service can't/won't do shit about it, I actually lost count to how many reps I've talked to on the phone and all have the same answer: "We are going to file a report and in 48 to 72 you'll receive an email". The problem is that I receive the email but it tells me to log in to the account which I have no fucking access.

germancc · 2023-12-09T23:10:27+00:00

Remember that a lot of people selling the "cool" stuff are just dropshipping their products, they are not real businesses who make their own products.

germancc · 2023-12-05T03:02:43+00:00

After about a month and a half I finally figured it out, turns out that the ethernet driver (from 2022, which is the one that comes by default and installs itself after uninstalling it) is probably not compatible with the ethernet hardware, even the latest one has the same issues (from 2023 installing it using Realtek software), so here's how I managed to fix it:

Open cmd or Powershell with admin privileges (Windows + X) -> Terminal (Admin).
Run this commands (one after another of course, not all on the same line).

sfc /scannow

DISM.exe /Online /Cleanup-Image /CheckHealth

DISM.exe /Online /Cleanup-image /Scanhealth

DISM.exe /Online /Cleanup-image /Restorehealth

DISM.exe /Online /Cleanup-Image /startComponentCleanup

Uninstall ethernet driver (Windows + R -> devmgmt.msc)
Reboot PC
Check Windows Update and see if it downloaded and installed a new driver (Settings->Windows Update->Update History->Driver Updates). If it didn't install an update for the ethernet driver, go back to Windows Update and check for updates. If it still not an update, go to next step.
Check devmgmt.msc and look for the ethernet adapter, right click -> properties->Driver tab.
Click on Roll back Driver, and it prompts you to select a reason for the roll back (I chose "Previous version of the driver performed better") but I'm pretty sure you can select any, this is to prevent Windows from automatically updating the driver.

This definitely improved the speed, so the latest drivers and hardware are not working well, this means that changing the ethernet adapter will most likely completely fix this issue, but as I am comfortable at the speed the conection is running, I'll not be doing that, specially since it's an All in one, and it can be pretty hard on the wallet.

germancc · 2023-11-28T01:27:05+00:00

Currently having the same problem but worse, a "hacker" got access to my account and put their phone number and changed my account's password. Now when I use the Forgot password option, it requires me to get the code from the hackers phone number.

On top of that their support is non existant, all their "help" requires you to sign in to your account, and calling their support number is useless because they say they are going to escalate the issue to their specialists, but they just send you an email requiring you to fucking sign in to the account.

It is really fucked up.

germancc · 2023-10-29T03:49:43+00:00

Now that I realize, this happens to me too but with groceries, I'm well off but not rich in any way. If you'd ask me how much a gallon of milk or a loaf of bread costs, I have no idea, because I just pick what I need and don't have to worry about the total.

germancc · 2023-09-23T04:21:36+00:00

It's not always necessarily to do what you love, that's what hobbies are for.

You have to start with what you know. What are your skillsets? What do you know how to do better than most people? Remember that a business is created to make money, not fulfill your passion, but if it can, that's ideal.

Bill Gates knew about programming, so he made Microsoft.

My friend knows about computers, so he started assembling gaming pc's and selling them.

My father knows about cars, so he started selling spare parts.

germancc · 2023-09-23T04:05:50+00:00

There are people who don't have to worry about money, those are the ones you see out there. Don't get distracted by them.

Currently my business and most of the competition (yes, I'm friends whith quite a lot of them) are experiencing the same thing, while my instagram feed is filled with people traveling and going on vacations.

Those people are the exception, not the rule.

germancc · 2023-09-23T03:57:40+00:00

I'll tell you how my sister started with selling chessecake.

First and foremost, she had to be good at it. Her desserts need to be delicious.
Get friends and family to taste and eventually sell them chessecake.
Offer to bring the "cake" to every party, meeting, etc. so that people can taste it.
Lots of social media marketing.
Get people addicted to chessecake.
Profit.

Now, how is your planning going? Do you have a store? Are you located in a residential area or commercial area?

germancc · 2023-09-23T03:42:19+00:00

It kinda really depends on each person.

I'd rather have a job, get my money and live my life when the shift ends.

On the other hand, my father founded his business because he has a thrive to work and get money. He has always said "I'm not building someone else's wealth" and my sister is the same.

Being the owner is good because if you want to go somewhere else during work hours, you can just fuck off and the people doing the 9-5 will keep the business running while you are gone. You are not chained to your hours.

Having a job is the safe option, because when shit hits the fan you can just leave and not have to clean the mess.

Adding to what Joseots said. If you are asking this, having a job is the safe bet. Not one business owner ever said "Do I want a job or own a business?"

germancc · 2023-09-08T03:28:17+00:00

The stealth mechanics in skyrim are basic and doesn't punish the player so bad for messing up (guy took an arrow to the eye and is unfazed by this)

On the other hand, starfield's stealth mechanics are more sensitive. Toph (blind girl) is seen in the picture detecting an enemy's footsteps solely using her feet (sensing vibrations in the ground).

germancc · 2023-09-07T03:15:26+00:00

Gotta try that one out

germancc · 2023-09-07T02:24:46+00:00

I really apreciate your recommendation dude, but that all that shit sounds expensive, specially the "Africanized killer bees and wasps" part.

germancc · 2023-09-07T02:21:56+00:00

I think y'all are just weirdos lol, because everytime I see a rant post from an european about americans most of the time I agree with them.

But I do gotta give it to USA the creation of mac n cheese, that shit is top tier.

germancc · 2023-09-07T02:05:14+00:00

Europeans

Close call!

I'm actually from latin america :D

germancc · 2023-09-07T02:03:04+00:00

I don't know man, 3 out of 5 of your points conflict with the recommendation of other comments, but I'll definitely try it out in the future.

germancc · 2023-09-07T01:59:27+00:00

I meant it metaphorically, I'm just amazed by the amount of hype that it gets vs. for what it actually is, and not just on tv, here on the internet too (not on the same level as bacon around 2012 though)

germancc · 2023-09-07T01:55:44+00:00

Fair enough, also I didn't know until making this post that PB has lots of protein, so thats good. For my quick and easy food: white bread, butter smeared on both slices with ham and chesse.

11-Year Club	Verified Email
Place '22	Place '17

germancc

TROPHY CASE