countif
 

I need to count the number of values in a range whose sum is less than a
specified value.
i have $85, i need: Mon - $20, Tues $10, Wed $50, Thur $10, Fri $20, i need
formula to show i have enough to cover my requirement to wed (3 days).

countif
 

In A1:A7 I have: Mon, Tue, ....
In B1:B7 I have $ amounts: 20,10,50,10,20....
In D1 I have the amount in hand: 85
I selected B1:B7 and in Conditional Formatting,
used Formula Is =SUM($B$1:B1)<=$D$1 and set a green fill
This seems to do what you asked for

The difference between COUNT and SUM is critical
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"nn" wrote in message
...
I need to count the number of values in a range whose sum is less than a
specified value.
i have $85, i need: Mon - $20, Tues $10, Wed $50, Thur $10, Fri $20, i
need
formula to show i have enough to cover my requirement to wed (3 days).