Calculating Inventory Changes

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.
 
D

dave!!

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
 

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

Top