Summing a column in a filtered range
Hi all, If i use the FILTER functions and extract 4 (say) columns of data and the third column has numerical values then how to i add the values in the third column. See below. I know that a formula like SUM(A2#) would work for a single column - but when when data is in the third column there does not seem to be anyway to access it. I hope this question makes sense - or am i missing something? many thanks, Peter Fiscal year Project Local Currency Cost Type Period 03 2014 GB1-IS002 255.26 Labour Period 03 2014 GB1-IS002 137.45 Labour Period 03 2014 GB1-IS002 107.99 Labour Period 03 2014 GB1-IS002 255.26 Labour Period 03 2014 GB1-IS002 255.26 Labour Period 03 2014 GB1-IS002 255.26 Labour Period 03 2014 GB1-IS002 255.26 Labour Period 03 2014 GB1-IS002 58.91 Labour Period 03 2014 GB1-IS002 157.08 Labour Period 03 2014 GB1-IS002 235.62 Labour Period 03 2014 GB1-IS002 157.08 Labour Period 03 2014 GB1-IS002 235.62 Labour Period 03 2014 GB1-IS002 235.62 Labour
What's the simplest way to make a genuinely random name selection system using Microsoft tools?
For example, suppose I have a list of participants in Excel and want to randomly select one winner without manually choosing from the list. Would you use RAND/RANDBETWEEN in Excel, Power Automate, or another Microsoft 365 approach? I'm also interested in preventing the same person from being selected twice when several winners are needed. I'd appreciate an approach that's easy for someone without much Excel or Power Automate experience to understand.
ALT+E+C to copy and Fill Handle not working.
Trying to use ALT+E+C to copy formula down the page. Will not proceed down the page and unable to escape out of the cell. Fill handle isn't working either. Tried Rebooting, removing the USB dongle and no help. There are no add-ins or conditional formatting. I'm at a loss, please help.
Sharepoint Save Nightmare
My organization uses Sharepoint sites for excel file storage. These files are using Co-Authoring and autosave is enabled. Whenever I am making changes to a file, I check it out, ensuring nobody else is in it, and check it back in and ensure the save and sync process completes without error. Myself and other individuals have been noticing recently that even when checking out files, there are still merge conflicts. My understanding is that if you check out, check in, and properly allow the file to save and sync, there should never be a merge conflict. This is becoming incredibly frustrating, and frankly, unacceptable as these files are relied upon by the organization to run the entire business. Losing critical data due to sharepoint server issues is not acceptable. Has anybody else run into issues with files not saving data, even when you're properly using all the features?Excel Insert Copied Cells Creates Blank Row
Whenever I try to copy row 2 below, right mouse click, and select Insert Copie Cells, I incorrectly get a blank row. This is in Excel safe mode with all add-ins disabled. Does anyone know how to fix this? See sample data below. Thanks. 1 32134 234234 45645 456 456 456 536 4567 456 456 456 456 456 456
Word and Excel stuck in Read and Print mode only
I have M365 Family Plan and one of my devices can't use Word or Excel. App tells me they are in Read and Print mode only. I have attempted multiple times to get support to resolve this via chat sessions, but they are unable to help. They have escalated this to Tier 3 Support and still no help. They recommended I go here for support. Here are some of the details. Case Number: 7108165505 (current one) Microsoft 365 Family subscription Word and Excel opening in Read Only / Print mode on one Windows 11 desktop Error when accessing the subscription management page Previous escalation to Tier 2 and Tier 3 Case marked as Resolved despite the issue remaining unresolved Note that extensive troubleshooting has already been completed and that you believe the issue may be related to subscription validation or account provisioning rather than the local Office installation.
