How do i count negative vales only in a column?
How do i count negative vales only in a column?
Assume your data is in column A, rows 1:15 =COUNTIF(A1:A15,"<0"). This will not sum the negatives, but will count the number of negative values per your post.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thanks for the help, the other thing I need to do is add up those negative values
Just change the word COUNT to SUM
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks