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

MJ06

New member
Joined
Aug 5, 2013
Messages
1
Reaction score
0
Points
0
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
BCDEFGHIJ
-1223
800
-176
300
-142
-226
-223
-48
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
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.
 
Top