Google sheets - How to use sumif or sumifs to sum cells in a range based on a condition
In Google sheets you can use sumif to conditionally sum values in a range depending on a criteria. For example the following formula will sum numbers »
Google sheets - How to use countif to count the number of matching cells in a range
In Google sheets you can use countif to conditionally count cells in a range. For example the following formula will count numbers larger than zero in »
C# - How to create, build and run a "hello world" console app on Linux
This post describes how to create a simple Console application and run it on Linux, for this we will be using WSL (Windows Subsystem for Linux) »
C# - How to Work with Files and Folders
In C# you have several ways to interact with files and folders, the most common are the File, Directory and FileInfo classes. Using these classes you »
Getting Conquest: Frontier Wars to work on Windows 11
If you are like me and know about the epic 2001 game Conquest Frontier wars you may have run into some issues when starting this game. »
Blackduck synopsys scan script no longer working and returns 404 as of March 2023
Is your synopsys scan no longer working as of the 1st of March 2023? Well it is because it is no longer there (404). It has »
Git - How to reset changes from a specific commit
You can revert a single commit in git using git revert <commit>, below is a step by step guide on how to do this. »
Git - How to force a git pull and overwrite local changes
In this post we will use a newly created remote repository and two local repositories cloned from that remote. We will then push a change and »
C# HttpClient - How to add a JWT bearer token to a HTTP request
You can add a JWT bearer token to a request by adding it to the Authorization header with a bearer scheme in front of the token »
How to set up logging using Serilog in ASP.NET with or without dependency injection
The easiest way to setup serilog is to add the Nuget packages and then configure it in your program.cs or startup.cs file. In this »