Number of negative values

[j.farr3ll]

I'm sure this is very simple aswel,

I have a table with columns from a to av and row1 has the column headings, and the rest of the rows contain values which are eathier positive or negative.

I want to create a new column which shows how many negative values there are per row.

Thanks James

[oldchippy]

Hi,

Try this

=COUNTIF(A2:AV2,"<"&0)