Results 1 to 3 of 3

IFCOUNT help please!!

This is a discussion on IFCOUNT help please!! within the Excel Questions forums, part of the Question Forums category; THis will be easy for you guys, but I'm brain dead today... I'm writing a stmt. and want to count ...

  1. #1
    New Member
    Join Date
    Feb 2004
    Posts
    13

    Default IFCOUNT help please!!

    THis will be easy for you guys, but I'm brain dead today... I'm writing a stmt. and want to count the number of times the number 10, 11, 12, 13, 14, 15, 16, 17 occur in a colum. Is there a way to write it using >< signs?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,948

    Default Re: IFCOUNT help please!!

    Hi, welcome to the board !

    Try using

    =COUNTIF(A:A, ">=10") - COUNTIF(A:A, ">17")
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    New Member
    Join Date
    Feb 2004
    Posts
    13

    Default Re: IFCOUNT help please!!

    THANK YOU!!! Works!!!!!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com