Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
Credit Card # | Setting up and Configuration of Excel | |||
Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) |