A
Alonso
Hi
my problem is that I have in cell A1 (merged with A2) the name of one item
on B1 is the stock
and in B2 is the number of items we need for the month
on A3 (merged with A4) is another item
again, b3 = stock
B4 = needed
What I want to do is
(1) to sum all the items on stock
(2) to sum all the items needed for that month
one way will be
STOCK =A1+A3+...
NEEDED = A2+A4+...
it's there another, simpler way??
the items could reach a 100, and I don't want to end
STOCK =A1+A3+...+A199
my problem is that I have in cell A1 (merged with A2) the name of one item
on B1 is the stock
and in B2 is the number of items we need for the month
on A3 (merged with A4) is another item
again, b3 = stock
B4 = needed
What I want to do is
(1) to sum all the items on stock
(2) to sum all the items needed for that month
one way will be
STOCK =A1+A3+...
NEEDED = A2+A4+...
it's there another, simpler way??
the items could reach a 100, and I don't want to end
STOCK =A1+A3+...+A199