sum limit and marking
 

Hello,

My question is regards to marking where my data is at its limit. For
example, if I have data for usage, but I want my limit to be at 100 items and
have it mark where the limit is so I know when and where I had to put in an
order.

For example:

Usage Limit
50
50
10
30
25 X
50
25
25 X

So at A6 and A9 I had put in a new order.

Is there a formula to mark when and where this limit occurs?

Thanks

sum limit and marking
 

I am having trouble visualizing the context in which you are working. I
think you are talking about something equivalent to a simple stock
reorder system, so I will use that terminology.

If "Usage" and "Limit" are in A1:B1, with the posted data in A2:B9, then
=IF(init+COUNTIF(B$2:B8,"X")-SUM(A$2:A9)<reorder,"X","")
in B9 may be what you are looking for, where init is the initial stock
that you are using, and reorder is the stock level below which you want
to reorder.

Jerry

Sum Limit and marking wrote:

Hello,

My question is regards to marking where my data is at its limit. For
example, if I have data for usage, but I want my limit to be at 100 items and
have it mark where the limit is so I know when and where I had to put in an
order.

For example:

Usage Limit
50
50
10
30
25 X
50
25
25 X

So at A6 and A9 I had put in a new order.

Is there a formula to mark when and where this limit occurs?

Thanks