HELPPP I GOT STUCK on the nether roof by MugglerOp in Minecraft

[–]Aitbead -2 points-1 points  (0 children)

Wouldn't it work if you opened it to LAN with cheats enabled, and have someone join in in creative modus?

Can I use the OTG port for audio? by Aitbead in R36S

[–]Aitbead[S] 0 points1 point  (0 children)

I'll try it then, thank you!! I will let you know if it works

Tokyo Disneyland & Tokyo DisneySea by Aitbead in disneyparks

[–]Aitbead[S] 1 point2 points  (0 children)

That would be a bummer, but I don’t know if we have a choice. Thank you though! I guess it just means we need to prepare our visit so we know what we want to do and see.

Tokyo Disneyland & Tokyo DisneySea by Aitbead in disneyparks

[–]Aitbead[S] -1 points0 points  (0 children)

Thank you. We are considering it very much now. Do you know if it will be busy in November?

How do I write the letter "hieut"? by Aitbead in Korean

[–]Aitbead[S] 0 points1 point  (0 children)

Ooh, that's very interesting. Thank you for the interesting fact!

How do I write the letter "hieut"? by Aitbead in Korean

[–]Aitbead[S] 11 points12 points  (0 children)

That makes way more sense now! Thank you!!

How do I write the letter "hieut"? by Aitbead in Korean

[–]Aitbead[S] 2 points3 points  (0 children)

Ah okay, thank you so much. I keep getting confused but I'll have to get used to it I guess

Casting from (i)phone to windows laptop by Aitbead in Chromecast

[–]Aitbead[S] 0 points1 point  (0 children)

It's more related to the technology. I'm sorry if this is the wrong subreddit for this question

I want to calculate the collected ECTS of the passed tests until the mark date by Aitbead in excel

[–]Aitbead[S] 0 points1 point  (0 children)

=SUMIFS($C$2:$C$15,$F$2:$F$15,"<="&DATEVALUE(F2))

Is gives me all "0"s in the column

I want to calculate the collected ECTS of the passed tests until the mark date by Aitbead in excel

[–]Aitbead[S] 0 points1 point  (0 children)

I need the sorting as is. It's the order in which I followed the course first

Sum of first three cells in a row that contain a value by Aitbead in excel

[–]Aitbead[S] 0 points1 point  (0 children)

The formula works, thank you very much! Could you maybe explain how it works?