Results 1 to 3 of 3

Thread: Calculating frequencies from worksheet to worksheet.

  1. #1

    Calculating frequencies from worksheet to worksheet.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello, i've had a look through the previous posts but am unable to find what i am looking for.

    If it is possible, i want my spreadsheet to calculate various ways.
    The main one i am struggling with is, I do jobs in various areas of the country, what i would like to happen, is when i input data onto my main sheet, is for the sheet to calculate how many jobs i do in a certain area of the country.

    EG,

    Bonded windscreen in Manchester
    Bonded windscreen in liverpool
    etc etc, on my final worksheet, add up each time i work in the separate areas of the country.

    Have worked with excel for some years but have had a couple of years off and am a little rusty.

    Thanks in advance, Reg

  2. #2
    Good morning,

    If you have the location in it's own column, you could have a separate master list of locations and then use countif (or countifs) to give the total. I.e.:

    Location
    X
    X
    Y
    Z
    Z
    Z

    MASTER LIST
    X =countif(---Location Range---, cell that "x" is in) and drag down ** = 2
    Y ** = 1
    Z ** = 3

    Hope this helps,

  3. #3
    I see what you mean, yes that makes sense. But still struggling. I have an image to post of my spreadsheet, but as yet i am unable to post it due to me being new and having a low post count.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •