Is there a way in an excel spreadsheet that all the negative numbers in each row and column can be added.?

Question

If so then what would the function would you use?

Answer 1

Yes it can be done using the "SUMIF" command.

Assuming you have numbers in cells A1 to A5 the equation would be:

=SUMIF(A1:A5, "<0")

It will only return the numbers less than zero, you can do the same for greater than zero by copying the function and replacing the "<0" with ">0".

Don't forget to keep the double quotations "" around the less than sign.

Answer 2

click interior the reference tab of the row at present decrease than the row you desire to unhide and from the pop up menu choose Unhide Row ... click interior the reference tab of the column at present to the your best option of the column you desire to unhide and from the pop up menu choose Unhide Column ...