Counting Cells (COUNT, COUNTIF, COUNTIFS)
COUNT =COUNT(value1, [value2], …) Counts the number of cells in a range that contains numbers COUNTIF =COUNTIF(range, criteria) Counts the number of cells within a range that meet the given …
Excel Summing up numbers (SUM, SUMIF, SUMIFS)
SUM =SUM(number1, [number2], …) Adds all the numbers in a range of cells SUMIF =SUMIF(range, criteria, [sum_range]) Adds the cells specified by a given condition or criteria SUMIFS =SUMIFS(sum_range, criteria_range1, …
Hassio/Home Assistant: Integration with Google Home
This post is to take you through how to integrate your Google Home with your Home Assistant/Hassio. The Home Assistant website has a detailed guide including links at the following …
Hassio/Home Assistant: Enabling Remote Access
In order to access your Hass.io instance from outside of your network, you will need to enable remote access. This is also a prerequisite for enabling the Google Home integration. …
Hassio/Home Assistant: Installing a Sonoff Switch (Tasmota Firmware)
The Sonoff switches that have been flashed with Tasmota Firmware are compatible with Home Assistant/Hassio. The following guide will take you through the steps to install the required components to …
Hassio/Home Assistant: Installing a Ring Doorbell and simple automations
The Ring doorbell system is compatible with Home Assistant/Hassio. The following guide will take you through the steps to install the Ring Doorbell component and sensors to allow you to …
Hassio/Home Assistant: Initial Installation Guide
Home Assistant is an Open source home automation tool that is constantly being updated and enhanced through contributions from a large DIY community. Home Assistant is perfect to run on …