Find the Average in a Range To find the average value for a range containing error values—such as #DIV/0!, or #NAME?—use the AVERAGE, IF, and ISNUMBER functions together in an array formula. Sometimes, such errors are generated in an incomplete worksheet, and these errors will be eliminated at a later time by the addition of new data. If you need to find the average value for the existing data, you can use the AVERAGE function along with the IF and ISNUMBER functions in an array formula to give you the average while ignoring the errors....

Social media consultant Matt Navarra initially spotted the potential feature on Thursday. His screenshots posted to Twitter shows how you would upload a photo and apply filters or edits through Instagram’s desktop website. Facebook spokesperson Christine Pai confirmed to Bloomberg that the feature is being tested. “We know that many people access Instagram from their computer. To improve that experience, we’re now testing the ability to create a Feed post on Instagram with their desktop browser,” she said....

How Storage Evolved In the early years of the computer revolution, floppy drives were widely used to share data files. Today, however, the average person’s storage needs far exceed floppy capacities. Businesses now maintain an increasingly large number of electronic documents and presentation sets, including video clips. Home computer users, with the advent of MP3 music files and JPEG images, also require vastly greater and more convenient storage. Central file servers use basic client/server networking technologies to solve some of these data storage problems....

Much like pairing a PlayStation 5 (or PS4) controller with a Mac, Nintendo controller support isn’t new for Apple’s computers—but up until now, it hasn’t been available for its mobile devices. It turns out, though, that buried among the multitude of new functions coming to iOS 16 and iPadOS 16 is compatibility with Bluetooth Nintendo controllers. Once the iOS 16 developer beta became available, it was only a matter of hours until some began to discover the new feature....

The Messenger app can already encrypt your messages so no one can read them in transit, but soon, Facebook will also allow you to encrypt your stored message history to prevent anyone, including law enforcement, from coming after your data through a back door. This may lead to Facebook Messenger becoming one of the most secure messaging platforms. The trouble is, nobody trusts Facebook. “I don’t think people have issues with the security features of Facebook itself, but rather what they do with our data,” Andreas Grant, a network security engineer at Networks Hardware, told Lifewire via email....

The allure of Kindle Vella is in its focus on the interaction between authors and readers. The former can directly address their audience using the author’s notes at the end of each episode/chapter, while the latter can encourage writers with Faves and thumbs-ups on their stories. Readers also can use in-app currency, called Tokens, to purchase additional story chapters as they become available—with 50% of the revenue going directly to the author....

Short Stuff There are also debut works like Bard Constantine’s young adult fantasy “The Pale Lord,” Ryan King’s science fiction story “Earth’s Exiles,” and Callie Chase’s dystopian “Bug.” Nothing grabbed my attention until I found “A Dog’s Life” by the author John Sibley. The narrative nonfiction structure of this book made it an easy read as a serial. As much as I enjoyed Sibley’s work, I wish there were some better-known nonfiction authors available on the Vella store....

Design: Small and versatile If you’ve been considering the Kobo Clara HD, but wish it were waterproof, the Kobo Libra H2O provides a happy alternative. It’s rated IPX8, which means you can definitely take this with you in the bath or pool, and it’s safe to submerge in up to 6.5 feet of water for an hour if you feel like taking a dip with it. Like its siblings, the Kobo Libra H2O features a responsive touchscreen that can handle touch commands without trouble....

The Lenovo 130S-11IGM is an interesting little machine for the budget-minded user. Down at the bargain basement of laptop prices you might expect to find lackluster performance and cheap quality. To be fair, this isn’t a fast laptop by any stretch, nor is it the most premium build out there. But, considering it does run Windows 10, and does so way under $500, your expectations will (and should) be adjusted accordingly....

Despite its name, the $49 Essential is a smart speaker hiding inside a timepiece. And that change in form somehow makes all the difference. There’s something innately comforting about glancing at the time on this classic-looking design in a world that’s been invaded by orbs, lozenges, and other strange smart-speaker shapes. You instinctively know what the Smart Clock does because of its glowing numerals that look right out of a 1980s-era bedside clock....

The new Thinkpad Z series, announced today at CES, brings some new and innovative features to the 30-year-old Thinkpad line of laptop computers. First and foremost? They will be among the very first laptops powered by the blazingly fast AMD Ryzen PRO 6000 U- and H-series processors. The Thinkpad Z13 ships with an AMD Ryzen Pro 6000 U-series process with an optimized Ryzen 7 Pro chip for increased audio and video performance....

When the E4200 Default Password Doesn’t Work If the default admin password doesn’t work, the password may have been changed to something more secure. If you don’t know the new password, a reset will bring the router back to its factory default settings so that the default password works. Here’s how to reset the E4200 router: Resetting the E4200 resets the username and password and also any custom settings you configured....

Availability of Command Prompt Commands A number of these commands are very similar to MS-DOS commands. However, the Command Prompt in Windows 8 is not MS-DOS, so the commands are not correctly referred to as MS-DOS commands. We do have this Complete List of MS-DOS Commands if you really are using MS-DOS and are interested. Similarly, not all Command Prompt commands are carried over to new Windows operating systems as they are released....

Overall Findings Both the MacBook Air and MacBook Pro are great laptops that provide some of the best performance and battery life on the market. They even share many design features, including Retina displays and backlit keyboards. While the Air is no slouch, the performance potential of the Pro is hard to beat. You can even upgrade to a 16-inch Pro if you’re looking for a larger MacBook with more horsepower....

If you want to listen to music on the go but abhor earbuds, then on-ear headphones offer an attractive middle ground between comfort, audio quality, and portability. The Marshall Mid ANC proves that this middle ground does not have to be a compromise, and that some of the best wireless headphones live in this range. The question is whether or not they can justify their steep asking price. Design: Classic Vintage Style The Marshall Mid ANC headphones practically ooze style in their beautiful design, wonderfully reminiscent of Marshall’s renowned guitar amplifiers....

Whenever you create a new account for, well, anything, you may use a password manager to create unique and complex passcodes. But you probably still use the same email address for everything. Wouldn’t it be great if you could also create a unique email address to go with that strong password? Fastmail and 1Password have teamed up to offer “masked” email addresses, which are just that. You can automatically generate a new email address at sign up, and it will automatically forward to your regular inbox....

Quake, Doom, Call of Duty. These are all games that had a lasting impact on how video games within their genres evolved. For fans of role playing games (RPGs), BioWare’s early action RPGs, like Mass Effect, helped show the impact players can have on a game when they’re actually given control to make meaningful decisions in the story. Mass Effect Legendary Edition captures the heart of the original titles perfectly, without ever stepping too far outside the box or trying to fix anything about the original experience—which is both good and bad....

Complete with the complexities and connections of a long-form jigsaw puzzle, this world created by a small cadre of live broadcasters on Bigo Live is a complicated one that moonlights as a digital reality show. And the self-dubbed “main girls” are the leading attraction. The Singapore-based live-streaming app is a little-known secret here in the West, not even cracking the top 20 most-used social media platforms, according to data compiled by Statista....

Synthesizers are all pretty much the same, in principle anyway, so a basic, well-designed unit like the Mavis is a great way to learn. The twist here is that, just by plugging cables from one section to another, you can radically alter how it sounds and behaves, allowing even the most advanced player to go wild. “I produce synth-based music quite extensively, and I have been mentioning the Moog Mavis to a bunch of friends who produce music in the past few days....

Take USB-C; it’s finally becoming a more universal option and can transmit lots of data and provide plenty of power for devices. The list goes on, but the fact is the side of my desk is a tangled mess of charging cords. I realized how bad the situation had become when I was packing for a summer vacation trip. Admittedly, I’m not a light packer when it comes to technology and travel, but the cord situation was ridiculous....