Help with credit Limit Summary

[Robin]

I need to compute the number of customers that are at and below their credit
limit then compute the number that are above their limit. I've tried using
sumproduct and get an error value and tried count if and get a 0.

 

[aidan.heritage]

I need to compute the number of customers that are at and below their credit
limit then compute the number that are above their limit. I've tried using
sumproduct and get an error value and tried count if and get a 0.

I take it you have a credit limit column and a current balance column
- if so, sumproduct will work IF there are legitimate values in place
in both columns - I'm happy to look at sample files (email should be
in clear view)