Simple excel question

Viewing 10 posts - 1 through 10 (of 10 total)
  • Simple excel question
  • Premier Icon wonny j
    Subscriber

    I’ve got a sheet with several columns and about 1500 rows. I’m using autofilter to do basic analysis on the data.

    If I autofilter search for a certain text input, say “south”, is there a command that will let me count the number of entries of “south”?

    Premier Icon jam bo
    Subscriber
    Premier Icon wonny j
    Subscriber

    and what is it o’wise one?

    psychle
    Member

    highlight the cells and on the bottom right of the screen there’s a wee little box that you can right click on (should say NUM I think), right click on this and choose which one you want it to report (in your case it’d be Count Nums).

    Premier Icon molgrips
    Subscriber

    Er look in the help under functions.

    It’s something like COUNT maybe, I forget.

    DrRSwank
    Member

    You could put a column of “1” all the way down and just sum this. The sum corrects depending on the autofilter.

    Premier Icon wonny j
    Subscriber

    Ah lovely, that’ll do.

    I’m a bit allergic to excel help function.

    Premier Icon wonny j
    Subscriber

    I did the “1” count already, but thought there must be a better way

    Premier Icon Nick
    Subscriber
    McHamish
    Member

    =COUNTIF(A1:A2,south)

    Change A1:A2 to the range.

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

The topic ‘Simple excel question’ is closed to new replies.