Calculating Inventory Changes

  • Thread starter Thread starter Harry
  • Start date Start date
H

Harry

The spreadsheet being used shows inventory data. Each line
on the spreadsheet has its own unique item. The columns
for each of these items shows the on hand inventory qty by
month

For example:
b1 c1 d1 e1
April May June July
Shirt 1 6 8 10

What formula can be used that calculates the about of
times the inventory changed. In the above example the
answer would be four.
 
in the column next to july put
{=SUM(1/COUNTIF(range,range))}

the {} mean its array entered (when done typing in the formula hit
ctrl+shft+enter)

range = 1,6,8,10
 
Back
Top