countif

[nn]

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).

 

[Bernard Liengme]

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