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. Feb 5th, 2004, 05:11 PM #1
    devans
    devans is offline
    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?
    Reply With Quote Reply With Quote
  2. Feb 5th, 2004, 05:13 PM #2
    Juan Pablo González
    Juan Pablo González is offline
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,945

    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
    Reply With Quote Reply With Quote
  3. Feb 5th, 2004, 05:54 PM #3
    devans
    devans is offline
    New Member
    Join Date
    Feb 2004
    Posts
    13

    Default Re: IFCOUNT help please!!

    THANK YOU!!! Works!!!!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules


DMCA.com