Daniel writes guides on how to use the internet, explainers on how modern technology works, and the occasional smartwatch or e-reader review. He especially likes deep diving into niche topics that ...

I keep running into situations in Excel where I want to calculate a conditional sum, but my criterion is something along the lines of "Include cell B1 if cell A1 is a number, likewise B2 and A2, B3 ...

Microsoft Excel's SUMIFS function calculates the sum of values in a range of cells based on multiple conditions. It avoids the need for complex filtering, and its conditions can be numbers, text, or ...

There might be some numbers you're missing when summing it up.