Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,887 questions
5 answers
One of the answers was accepted by the question author.
What is the best way to resolve or to simplify the following excel functions using excel 2020 or greater
Can I use the IFS function or LET, SUMIFS? =SUM(IF($B$2=0,0,IF($B$2>$I$2,4,IF($B$2=$I$2,2))+IF($C$2=0,0,IF($C$2>$J$2,4,IF($C$2=$J$2,2))+IF($D$2=0,0,IF($D$2>$K$2,4,IF($D$2=$K$2,2))+IF($E$2=0,0,IF($E$2>$L$2,4,IF($E$2=$L$2,2))))))) If I have a…
Microsoft 365 and Office | Excel | For home | Windows
asked
2026-08-06T01:37:13.0266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 34%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
LeRoy Cofield
40
Reputation points
commented
2026-08-11T01:13:21.0333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Barry Schwarz
6,106
Reputation points
3 answers
Expires on 11/08/2026 and no update appears
Hello, I have version 25H2 (OS build 26220.8925), which says it expires on 08/11/2026, and no update appears in Windows Update. What should I do—switch to the experimental channel instead of the beta? Regards
Windows Insider program | Windows Insider preview | Other
asked
2026-07-30T06:47:03.6966667+00:00
Monica Porta
0
Reputation points
recommended
2026-08-11T01:12:39.0433333+00:00
Johnny55
5,155
Reputation points
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
Your Microsoft account has been hacked
Your Microsoft account has been hacked, and even the email and phone number linked to your account have been changed, so even if you try to recover your account, you can't even try to log in.
Outlook | Web | Outlook on the web for business | Security
Outlook | Web | Outlook on the web for business | Security
Managing security settings and protections in Outlook on the web for business
226 questions
asked
2026-08-10T02:07:09.89+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 31%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW8%3C/text%3E%3C/svg%3E)
WhiteElla-8396
20
Reputation points
accepted
2026-08-11T00:36:02.56+00:00
WhiteElla-8396
20
Reputation points
2 answers
One of the answers was accepted by the question author.
Regarding a problem with Microsoft Forms
I was checking the responses I received through Forms in Excel. I did some test checks myself to make sure it was working correctly, but I encountered problems such as multiple entries of data that I had only sent once appearing in Excel, and…
Microsoft 365 and Office | Microsoft Forms | For business
Microsoft 365 and Office | Microsoft Forms | For business
A web-based tool in Microsoft 365 that enables users to quickly create surveys, quizzes, polls, and feedback forms.
1,693 questions
asked
2026-08-10T06:59:05.2+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 55.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Anderson Gs
20
Reputation points
accepted
2026-08-11T00:32:54.96+00:00
Anderson Gs
20
Reputation points
1 answer
One of the answers was accepted by the question author.
How to set elegible appoinment dates, skipping weekends and holidays in EXCEL 365
I want to set up a formula to allow days that can be booked for appointment, in any case a date was a weekend or one of our national g=holidays it wont be available. for the year it should shouw when appointment can happen or when a date is pciked or…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
20,975 questions
asked
2026-08-09T10:23:45.4866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 63%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Amin
40
Reputation points
commented
2026-08-11T00:19:34.64+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 30%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERN%3C/text%3E%3C/svg%3E)
Ruby Nguyen
1,965
Reputation points
Independent Advisor
1 answer
One of the answers was accepted by the question author.
Billing Policy for the Cohere Rerank Model in Microsoft Foundry
Hello, I am an Azure engineer based in Korea. I am currently using the Cohere-rerank-v4.0-fast model deployed in Microsoft Foundry, and I would like to clarify how billing is calculated for this model. According to the official documentation, Cohere…
Foundry Models
Foundry Models
A catalog of AI models in Microsoft Foundry that you can discover, compare, and deploy using Azure’s built‑in tools for evaluation, fine‑tuning, and inference
193 questions
2 answers
One of the answers was accepted by the question author.
Wsus 2022 and later
Why there is no windows 2022 and later on wsus?
Windows for business | Windows Server | Devices and deployment | Other
asked
2026-07-31T02:41:58.6433333+00:00
Handian Sudianto
7,461
Reputation points
accepted
2026-08-11T00:00:39.0266667+00:00
Handian Sudianto
7,461
Reputation points
1 answer
One of the answers was accepted by the question author.
PKCS Device Certificate
Is UPN can work if the PKCS set to device certificate?
Windows for business | Windows Server | Directory services | Certificates and public key infrastructure (PKI)
asked
2026-08-09T23:59:05.2666667+00:00
Handian Sudianto
7,461
Reputation points
accepted
2026-08-10T23:58:30.02+00:00
Handian Sudianto
7,461
Reputation points
2 answers
One of the answers was accepted by the question author.
Problem with office 365
Had a license Microsoft office Home and student but used the professional license of my work for 2 years. Would like to go back to my personal license but cannot do it. The apps ( Word/ Excel and powerpoint ) won't work. I changed to my personal email…
Microsoft 365 and Office | Install, redeem, activate | For home | MacOS
Microsoft 365 and Office | Install, redeem, activate | For home | MacOS
Processes in Microsoft 365 for setting up Office apps, redeeming product keys, and activating licenses.
2,771 questions
asked
2026-08-07T19:01:55.7966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 74%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Laurence Yan Luk
20
Reputation points
commented
2026-08-10T23:55:45.2366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 84%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXD%3C/text%3E%3C/svg%3E)
Xavier-D
12,775
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
The OneNote Web Clipper has stopped working.
The OneNote Web Clipper has stopped working. I use Chrome. It requires you to sign in. When you try to sign in, the following message appears: Server Error in '/siteapi' Application. Runtime Error __Description:__An application error occurred on the…
Microsoft 365 and Office | OneNote | Other | Other
Microsoft 365 and Office | OneNote | Other | Other
A family of Microsoft products that enable users to capture, organize, and reuse notes electronically.
150 questions
asked
2026-08-05T12:18:40.94+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 88%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELP%3C/text%3E%3C/svg%3E)
Lukáš Pešout
20
Reputation points
edited a comment
2026-08-10T23:54:07.6466667+00:00
Xavier-D
12,775
Reputation points Microsoft External Staff
Moderator
1 answer
One of the answers was accepted by the question author.
SMTP AUTH is not working for a specific mailbox in Exchange Online
Hi, I’m having an issue with SMTP authentication in Exchange Online. I have a Microsoft 365 mailbox that needs to use SMTP AUTH to send emails from an application. However, the application cannot authenticate and fails when trying to send email. I…
Exchange Online
Exchange Online
A cloud-based service included in Microsoft 365, delivering scalable messaging and collaboration features with simplified management and automatic updates.
7,400 questions
asked
2026-08-10T06:03:52.7+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 81%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Johanson David
20
Reputation points
accepted
2026-08-10T23:26:36.4466667+00:00
Johanson David
20
Reputation points
2 answers
One of the answers was accepted by the question author.
What modules to be studied for AB-100
This link does not clearly show which modules need to be studied for the AB-100 Expert exam. Could you please let me know which modules need to be completed?
Community Center | Not monitored
Community Center | Not monitored
Tag not monitored by Microsoft.
57,775 questions
asked
2026-08-09T08:13:00.3266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 9%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Salgaduge Dias
40
Reputation points
accepted
2026-08-10T23:22:01.97+00:00
Salgaduge Dias
40
Reputation points
3 answers
One of the answers was accepted by the question author.
Upgrade to Windows 11 Insider Preview 29639.1000 fails with installation error 0x8007042b (Build 26H1 28120.2546 expiring soon)
Question / Problem I am trying to upgrade from my current Windows build 26H1 (28120.2546) to Windows 11 Insider Preview 29639.1000 (rs_prerelease). The upgrade repeatedly fails with the error Installation error – 0x8007042b. My current build expires on…
Windows Insider program | Windows Insider preview | Install, activate, and Windows update
asked
2026-08-09T15:24:34.71+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 56.00000000000001%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
Dirk Lehmann
20
Reputation points
commented
2026-08-10T23:05:54.1333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 1%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Paul Aquin
0
Reputation points
1 answer
account restricted on MSN
it has been weeks and weeks since my msn account has been restricted. I am no longer able to comment on articles. how does one fix this? why is it impossible to get technical support on this?
Community Center | Not monitored
Community Center | Not monitored
Tag not monitored by Microsoft.
57,775 questions
asked
2026-03-05T23:03:17.68+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 45%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
Michael Fitzgerald
5
Reputation points
commented
2026-08-10T22:47:12.5733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 22%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBN%3C/text%3E%3C/svg%3E)
Bryan Novak
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Problema al iniciar C:\Windows\System32\LogiLDA.dll
Tengo problemas para iniciar sesion en mi maquina. no me aparece el logeo al windows y cuando aparece y me logeeo, me envia el mensaje de qu eno puede encontrar ese archivo problema al iniciar C:\Windows\System32\LogiLDA.dll Yo tengo Windows 11
Windows for home | Windows 11 | Accounts, profiles, and login
10,047 questions
asked
2026-08-10T18:15:53.6266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 52%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Tania Diaz
20
Reputation points
accepted
2026-08-10T22:45:18.01+00:00
Tania Diaz
20
Reputation points
3 answers
One of the answers was accepted by the question author.
OneDrive problems
My storage in full on my one drive account. I was trying to stop the sync process and delete the files that were already backed up from my one drive account. Instead it deleted the files from my laptop and now I am unable to restore them. Also before I…
Microsoft 365 and Office | OneDrive | For home | Windows
Microsoft 365 and Office | OneDrive | For home | Windows
A Microsoft file hosting and synchronization service.
16,121 questions
asked
2026-08-10T19:33:47.86+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 73%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEK%3C/text%3E%3C/svg%3E)
Ed Kroning
20
Reputation points
edited an answer
2026-08-10T22:31:00.8866667+00:00
Craig Long
18,630
Reputation points
1 answer
One of the answers was accepted by the question author.
Unable to Deploy VPN Gateway in North Europe
Hello! I would like to confirm whether there is currently a backend limit or capacity constraint preventing the deployment of a VPN Gateway in the North Europe region. A customer reached out to me regarding this issue, and when I attempted to reproduce…
Azure VPN Gateway
Azure VPN Gateway
An Azure service that enables the connection of on-premises networks to Azure through site-to-site virtual private networks.
2,174 questions
asked
2026-08-10T19:54:30.8566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 12%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELK%3C/text%3E%3C/svg%3E)
LeRoy, Kevin
265
Reputation points
accepted
2026-08-10T22:26:12.8033333+00:00
LeRoy, Kevin
265
Reputation points
1 answer
One of the answers was accepted by the question author.
Co-Pilot is crippingly slow
Co-Pilot is crippingly slow when I type and when it answers. I have a 7800X3D 5070ti system. Windows 11 latest build.
Microsoft Copilot | Windows Copilot | App
Microsoft Copilot | Windows Copilot | App
An application or feature powered by Windows Copilot to assist users with tasks and productivity
264 questions
asked
2026-07-16T13:23:58.05+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 79%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Johnny Grinter
115
Reputation points
accepted
2026-08-10T22:03:18.4433333+00:00
Johnny Grinter
115
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Machine Learning Pipeline job failing during MLflow model logging on custom Docker environment
I am running an Azure ML v2 CLI pipeline job utilizing a custom curated environment built from Docker file base mcr.microsoft.com/azureml/openmpi4.1.0-ubuntu20.04. The compute cluster uses Standard_NC6s_v3 instances. When the training script reaches…
Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
3,693 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 23%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELO%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Unable to delete subnet because of orphaned SAL
I'm trying to delete an azure subnet but getting error "Failed to save subnet 'agent-subnet'. Error: 'Subnet…
Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
3,160 questions
asked
2026-08-10T19:47:51.4166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 93%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Prakhar Parimal
56
Reputation points
accepted
2026-08-10T21:50:04.5933333+00:00
Prakhar Parimal
56
Reputation points