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

Most people are still using Excel like it’s 2010 with functions like INDEX MATCH, SUMIFS, or VLOOKUP. In this video, we’ll ...

Have you ever struggled with Excel formulas, trying to calculate running totals only to be left with errors and frustration? Many of us have faced the challenge of managing datasets where each row’s ...

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

Q. Our company provides financial reporting audits and IT audits. The client invoices provide an itemized list of time spent on each type of audit, by auditor and date. Is there an easy way to provide ...