Inside Microsoft Office


Mystery solved: Find out how to use COUNTIF with non-contiguous cells

Inside Microsoft Office

by Kara Hiltz

This does bring up a strange problem that I’m sure puzzles many Excel users. And the workaround may seem like it’s from left field, but it works!

The key is to combine the COUNTIF function with the SUM function and the INDIRECT function. Sound crazy? Let’s take a look at an example. Let’s say you want to count the number of orders that total at least $50 in your worksheet, but the ranges[…]

 

Subscribe to Inside Microsoft Office

(get full access to archives and more)