Viewing 21 posts - 1 through 21 (of 21 total)
  • Excel HELP! pretty please
  • walla24
    Free Member

    Hello again, so I have this spreadsheet which details visitor numbers by hourly slots for the last three years.

    Each hour has a separate row.

    Is there a formula to pull the =SUM of all say 13:00 hour slots, 14:00 time slots etc etc?

    I basically want to show the footfall for the year by hour to show busiest hour etc.

    Cheers guys!

    jimdubleyou
    Full Member

    Probably easiest in a pivot table.

    edit: although I have had my Excel knowledge shown up before… 😯

    ThePinkster
    Full Member

    ^This^

    Stoner
    Free Member

    SUMIF will do it once you’ve got your timecodes sorted

    Have a mars bar if you get it right first time 🙂

    perchypanther
    Free Member

    you need SUMIF

    =SUMIF( range, “13:00”) for exanple

    edit: 11 seconds too late

    PlopNofear
    Free Member

    =SUMIF(D80:D100,”13:00:00″,F80:F100)

    poly
    Free Member

    If you want a formula some creative SUMIF would probably do it.
    I suspect pivot tables are the easiest(?) way to do it…

    And of course – Excel is not the best tool for the job!

    verses
    Full Member

    The ratio of “Movements” to “Visitors” is quite high? Is this tracking the Picolax visitors centre?

    mefty
    Free Member

    I would add a column with a IF formula referencin the time and then sum the column. This gives you an easy visual check everything is workiñg

    daniel_owen_uk
    Free Member

    Pretty much said, SUMIF will do it but it’s the ugly way.

    Pivot Table all day 🙂

    walla24
    Free Member

    Cool thanks, I will have a play with this mysterious ‘pivot table’ thing…..
    not sure why I keep getting asked to do excel work… 😀

    joshvegas
    Free Member

    Pivot table for sure

    People think its a dark art its not and you will become the excel master.

    joshvegas
    Free Member

    Pivot table for sure

    People think its a dark art its not and you will become the excel master.

    slackboy
    Full Member

    this is a simple pivot table and chart with your data. will give you an idea. They are great for summarising long lists of repeated data.

    Pivot Table

    the key with pivots is to get the source data in the same format and in named columns. in your spreadsheet remove the first row as that will create problems making the pivot table.

    as others have said, make sure the data formatting is correct for all the cells or you’ll get weird results when you summarise the data.

    walla24
    Free Member

    SUMIF will do it once you’ve got your timecodes sorted

    Have a mars bar if you get it right first time

    So no mars bar for me 🙁

    What do you mean sort out your time codes?

    joshvegas
    Free Member

    Disagree about the first row.

    Just don’t select it.

    walla24
    Free Member

    oh my life….that was way easier than pages of formula!

    slackboy
    Full Member

    Disagree about the first row.

    Just don’t select it.

    Fair point, but if OP doesn’t know anything about pivot tables then the first thing that will happen when he selects the data sheet is that it will fail because the first row doesn’t have column headings in it.

    joshvegas
    Free Member

    Its all goid success was achieved!

    joshvegas
    Free Member

    4am is the perfect break in time.

    Whats the address?

    joshvegas
    Free Member

    If you right click in the table you can make an interactive graph.

    Create pivot chart or something like that.

Viewing 21 posts - 1 through 21 (of 21 total)

The topic ‘Excel HELP! pretty please’ is closed to new replies.