Q. I read the June 2020 JofA article on SUMIF. I have tried to use it in my Excel spreadsheet, but it won’t work since I have multiple criteria. Is there a way to get SUMIF to work if you have more ...

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 ...

Here are a few quick methods of analyzing records to find out what's been paid and how much customers owe. If you work with transaction records, you probably need a way to track what’s outstanding and ...

Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...