countif

N

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top