Excel's SUMIF and SUMIFS functions both let you add up values that match criteria you specify. The problem is that many people treat them as separate tools: SUMIF for one condition, SUMIFS for ...

I have an Excel worksheet where I calculate 3D print jobs - time, filament used, cost, etc. As jobs are completed and paid for, my current practice is to use a strikethrough on that line to show that ...

Conditional formatting in Excel combines the filtering feature with a function to easily sum formatted cells, without using any coding. If you can only read one tech story a day, this is it. We use ...

Move beyond the basics of sums and averages. These tips open up all kinds of opportunities for working with spreadsheet data. Editor’s Note: This article was originally published in Sept. 2012 and the ...