countif

  • Thread starter Thread starter nn
  • Start date Start date
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).
 
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
 
Back
Top