Results 1 to 2 of 2

Thread: Need a formula to count Neg values, by colm header.

  1. #1

    Need a formula to count Neg values, by colm header.



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

    I have to following spreadsheet that is downloaded daily.

    I want to count the number of Negative values under Title H. However Title H can move in different downloads.
    The Title is always the same but can move....

    A B C D E F G H I J
    -1223
    800
    -176
    300
    -142
    -226
    -223
    -48

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,462
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =COUNTIF(INDEX(A:J,0,MATCH("H",A$1:J$1,0)),"<0")

    where A:J are column headers, and "H" is the column "title" in row 1 between A1:J1 to be searched.


Posting Permissions

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