Counting items across workbooks

  • I have an excel file with about 50-60 workbooks inside of it each containing data.

    I work for Albertsons and each tab is an individual store

    For example:

    One store (tab) might say

    Crackers 4ft

    Another store (tab) might say

    Crackers 12ft

    I want to go across workbooks and have it count how many stores use the 4ft set and how many use the 12ft set. I'm not sure if this is possible or how to even go about doing it. Any help would be much appreciated. Thank you.

  • Re: Counting items across workbooks

    I think that you mean that you ahve 50-60 Worksheets. You can do this providing the layout is the same in each sheet using COUNTIF, ie the number of 4ft Crackers should be in the same cell in each sheet..

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!