One of the most useful functions is SUMIF. Similar to the basic SUM function, this allows you to find the total of a set of values. What makes SUMIF different is that it will only include values that meet a specific criterion that you set. If you want to know how to use the SUMIF function in Google Sheets, follow our guide below. What is the SUMIF Function in Google Sheets?...

If you want to make decisions about the direction of your server, allowing people to vote can be a fair and democratic way to do so. You might also want to create a poll just for a bit of fun or to gauge interest in potential new ideas for your server. The good news is that setting up a poll in Discord is fairly quick and easy to do. If you want to know how to vote in Discord, here’s what you’ll need to do....

For this option to work, there are a few prerequisites you’ll need in place first. Once the video is playing, select the three dots at the upper-right corner of the Chrome window, and select Cast. This will bring up another window that will display all of the detected Google devices on your home network that the browser can cast that browser tab to. Choose the television your Chromecast device is plugged into....

Here’s how to watch Twitch on your Roku. How to Watch Twitch on Roku One option you have (for now) is using a private Roku channel called Twoku. This gives you access to Twitch streams without relying on an official app. It’s not perfect (there are bugs, and the app is updated rarely) but it remains the best option to watch Twitch on Roku. As with any private channel, Roku can also block or remove it at any time without notice....

According to the LA Times Hulu is planning to start up a new subscription service they will call “Hulu Plus.” The hopeful scenario is that Hulu Plus won’t change anything for already existing free content, but the idea is to include additional content that will only be available to subscribers. Currently, you can watch a decent variety of shows on Hulu, featuring shows from both public networks like ABC, NBC, and Fox to networks on paid cable channels like USA and Sci-Fi....

Tap Settings » Store. In the Store settings, adjust which apps should Automatically Download purchases from your iTunes account. The Store settings are individual to each iOS device so you will need to repeat this process on each of your iOS devices. Comment Name * Email * Δ Save my name and email and send me emails as new comments are made to this post.

Windows has a personalization feature that allows you to roll your images as a slideshow on your desktop. While this is great for making themes, I’ve also found another cool use for it. Here I’ll show you how to make a groovy color-changing background for Windows 7. Make a Color Changing Wallpaper for Windows 7 First around on the internet to find a cook image with a black background and a single object somewhere in the middle....

In turn, Nokia will pay Microsoft a fee for each copy of the operating system it uses on its phones. “How does Nokia benefit from this?” you ask… Nokia benefits quite a lot, and that’s because the company has spent a lot of cash developing Symbian for its smartphones (which didn’t go too far), and starting over really wasn’t an option. By “going Microsoft” they will be able to enter the market immediately with a huge cash infusion from Microsoft....

Here’s the quote from her presentation: Since the departure of former Windows and Windows Live President, Steven Sinofsky, Julie Larson-Green was promoted to lead Windows Software and Hardware Engineering and together with Tami Reller, they report directly to Microsoft CEO Steve Ballmer. What’s interesting is the 40 Million total its double the monthly level of Windows 7 over the past three years, according to an article by Paul Thurrott. Also, according to a post today on Microsoft’s Blogging Windows, Windows 8 is outpacing Windows 7 in regard to user upgrades....

Microsoft Officially Offering Solution to Disable Get Windows 10 app Microsoft’s next push is to get small business and enterprise to upgrade. Soon, the Get Windows 10 app will be extended to domain joined PCs running Windows 7 Professional and Windows 8.1 Pro. This is a critical group of Windows users, Microsoft knows it does not want to irritate them. Just for that, the company is providing technical instructions on how to block the Windows 10 upgrade....

Windows Insider MVP Program for Windows 10 The new award program places emphasis on Windows 10. Recognizing the best Windows Insiders who volunteer their knowledge of Microsoft’s flagship operating system in a number of areas such as forums, blogs, public speaking and authors. Users awarded as Consumer Security, Windows Phones, Surface, and Windows Experience MVPs are now Windows Insider MVPs. As part of the new program, Windows Insider MVPs will be recognized with a new award plaque and complimentary benefits....

Windows 11 Build 22000.51 This new Windows 11 Insider build contains much of what was announced at Microsoft’s event it held last week. This build includes the following: Start: Start puts everything you need on your PC at the center with a set of pinned apps and a cloud powered “Recommended” section that shows your recently opened files from both your PC and across your devices like your smartphone with OneDrive....

Today Microsoft released the Release Candidate for Hyper-V Server 2008 R2. Full speed ahead it seems at Microsoft. Microsoft is trying to narrow the gap with VMWare with the R2 release of Hyper-V Server, but they still have a long way to go. You can grab a Download Here. Here are the details on the Download page. Note: This is a pre-release version of Microsoft® Hyper-V™ Server 2008 R2 and not intended to be used in a production environment....

You can pick it up from the Official Microsoft site at . Just Click the Download button and then run the setup file. Once you finish installing, the Add-in will show up in Outlook under the Add-ins ribbon. The Bing Travel Planner will open up in its separate window. Unfortunately, as of now, the beta is looking pretty sad. The Bad It’s just a crummy browser that opens up the Bing website....

Windows 10 20H1 Preview Build 19028 Here is the list of fixes and changes added to today’s latest build: We fixed a recent issue that could result in Settings crashing when docking/undocking your device. This issue may have also impacted Action Center launch performance.We fixed an issue impacting the performance of the Printers & Scanners section of Settings loading.We fixed an issue resulting in the Other People section under Storage Settings not displaying the correct size used....

Windows 10 Build 21292 The news and interests section on the taskbar is receiving several updates including a more polished UI. Here is a list of what has been improved on with the news and interests feature: We fixed multiple issues impacting performance and reliability.We fixed an issue where an empty flyout would be shown after opening news and interests.We fixed an issue where the text on the taskbar button wasn’t being read by screen readers and some tooltips were missing....

Windows 11 Preview Build 22463 First off, Microsoft announced at TL;DR for Insiders in the Dev Channel which is as follows: Please see the new section at the end of this blog post outlining the type of builds and experiences you will see in the Dev Channel.It will be a little while before major new features show up. However, this build includes a good set of improvements and bug fixes. Speaking of fixes…The issue impacting the Taskbar where icons appeared misaligned and/or cut off is FIXED in this build!...

There isn’t a whole lot of information of what this update addresses. In typical Microsoft fashion, the update says “This update includes improvements to enhance the functionality of Windows 10.” There is a Microsoft Support page up, although it doesn’t spell out what exactly this update is addressing. Hopefully we’ll get more information on it in the coming days. This updated does require a system restart, and remember you can schedule when restart takes place....

Microsoft Teams Free The free version of Teams is available now and doesn’t require you to be an Office 365 subscriber. In fact, you don’t even need a Microsoft account to sign up; any email address will get you started. The free version is aimed at small to mid-size businesses and can be used by groups of up to 300 people. It includes unlimited chat and message search, unlimited app integrations, audio and video conference calling, 10GB of team storage plus an additional 2GB per person for personal storage, and a lot more....

An update for Windows Live Essentials users was announced last week from Microsoft. It mentioned that its entire suite of apps including Live Messenger, Mail, Photo Gallery, Movie Maker, Mesh and of course our favorite blogging tool, Windows Live Writer. Steven Abrahams, Windows Live lead program manager mentioned users will see new features including the ability to chat with Facebook friends, photo fuse in Photo Gallery and much much more....