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[…]