Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
I want to add all the negative numbers in a column in Excel - how would I do that? Thanks?
There are about 50 numbers in the column and I would like to add up just the numbers that are negative in a cell at the top of the page.
2 Answers
- garbo7441Lv 71 decade agoFavorite Answer
Assuming the numbers are in column A and your formula will not be in column A:
=SUMIF(A:A,"<0")
If your formula will be in the first cell in the column to be summed:
=SUMIF(A2:A100,"<0")
- 1 decade ago
Click the cell where you want the answer, then click on the fx button (up at the top), double-click SUM. Then it'll ask for the cells you want to add. Put the first cell number, then a colon, then the last cell number. It's hard to explain. I hope that's clear enough for you. If not, I tried.
