Professor Excel
countifs, excel, countif

COUNTIFS in Excel: Everything You Need to Know

The COUNTIFS function works similar like the SUMIFS function. But instead of adding up the values, it counts how many items with one or more criteria are in your table.

thumbnail, copy, paste, exact, ranges, exact ranges, persist, preserve

How to Compare Two Lists in Excel

Let’s assume, we have the following (although realistic) challenge: We got two lists which should have the same items in Excel. But they aren’t exactly the same so that we need to compare them. But how do we find out the best way, which items are missing in either one of the lists? Instead of comparing manually, there are some easy steps. […]