Community
3063 TopicsSumming rows values while a specific column answers a specific condition.
Its much smaller than the sheet I work with but for this example I want to scan column 1 representative and if the value in a cell form A2:A6="D" I want to sum its rows. in this case I expect the answer 3+1+8+1=13. Tried the sumif but it works for 1 column at a time and not scanning multiplied arrays. Tried sumproduct and still couldnt get the cell to show the total amount. since in my actual worksheet there are 37X57 array, going manually and put formula in each specific row is less ideal soo I am looking for a specific command to solve it and calculate along the data that changes on the sheet.21Views0likes1CommentHow to prevent Windows Explorer from saving paths
When I copy and paste a path into Windows Explorer is saves it. The problem I have is when I'm switching views from Details to Extra Large Icons. After type multiple paths the drop down of the saved paths covers the area that I'm working on. I have to click somewhere else on the screen to hide it. I tried tech support but was told this is by design and can't be changed. Does anyone know of a work around for this problem? Thank you.39Views0likes3CommentsFolder suddenly showing onedrive icon
Hi all this is weird Last night when I turned off my lap top there was no cloud symbol next to my folders. However when I turned it on I had to go through We will now finish setting up your computer. I skipped every thing and when I went to file explorer this had happened. why and can I get rid of the cloud my files and folders are not synced and never will be29Views0likes2CommentsPosts and comments not getting approved
Hello Tech Community Team, I’ve recently started contributing educational Azure lab posts to the Tech Community, but none of my posts or even my comments are getting approved or published — even after waiting more than 48 hours. I’m trying to actively participate and help others, and I want to make sure my account is not stuck in moderation or blocked from posting. Could you please check and let me know how to proceed? Thank you very much, Perparim Abdullahu23Views0likes2CommentsWindows 11 Pro 25H2 build 26200.6899 - pane preview error
Dear Microsoft Support, After I upgrade Windows 11 Pro 24H2 to 25H2 build 26200.6899, when I pane preview file, it showed the message "The file you are attempting to preview could harm your computer. If you trust the file and the source you received it from, open it to view its contenst." UNC path also error.69Views0likes2CommentsHow to distribute the value of one cell evenly in a sequence for the value of another cell?
Hi there, I'm trying to evenly distribute numbers (not a set value) to help with crocheting - taking the math out for testers/creators right now I have the blue row working as a sequence, however I can't work out how to divide it equally So for the example above; there are 20 rows, there needs to be 8 increases (1 every 2.5 rows). How do I get that information to show in the column next to my sequence (Rows)? If it's even possible - haha. I would like it to automatically work out like the below (manually entered) Thank you56Views0likes4CommentsOutlook 365 (classic) freezes syncing subscribed folders via IMAP
Win 11 home, with all current updates. Outlook 365 (365) Version 2510 Build 16.0.19328.20010) 64-bit; with all current updates. ISP: telusplanet.net (which is Google, with limited functionality), Servers: imap.gmail.com, port 993, SSL/TSL and smtp.gmail.com, port 465, SSL/TSL Protocol: IMAP. I was using POP before without any problems for years. The problem: When starting OL it downloads new mail messages OK. But after a while it freezes in ‘Synchronizing Inbox’ or rarely ‘Synchronizing Trush’ and does not download new messages from the server (which are visible in Gmail on Chrome) nor delete messages from the server, which were deleted locally. When this happens, to get it back, I need to shut OL down, wait, say 15 min, or longer, start it again and usually it is enough, occasionally I need to shut down and power the PC again. I have not uninstalled and reinstalled OL yet but am thinking of it. I use IMAP to sync mail, and Sync2 for contacts, calendar, and tasks – that works OK. I have tried just about anything possible, rebuilding profile, repairing OL, clearing cache, unlinking OneDrive, whatever I could think of, or what Copilot suggested, all to no avail. It is obviously very annoying. I believe, if it is happening to me, it must have had happened to others as well. It all started after switching from POP to IMAP. Any suggestion will be greatly appreciated, Jan138Views0likes4Comments