Excel doesn’t display negative times well, so here are two ways we can address this, including using the 1904 date system. We will utilize the ABS, IF, SUMIF and TEXT functions in the process.
Tag Archives | SUMIF
Here is a follow up post based on a question I received on my previous post about SUMIF & SUMIFS…..
Here are the differences and similarities in using the SUMIF & SUMIFS functions in Excel…..
Here are a couple more great uses of SUMPRODUCT in Excel…..
Here’s how we can use SUMPRODUCT instead of SUMIF in Excel when adding columns of data based on a certain criteria…..