Help with credit Limit Summary
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. |
Help with credit Limit Summary
On May 2, 3:45*pm, Robin wrote:
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) |
All times are GMT +1. The time now is 02:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com