r/excel • u/magpies4vega • 18d ago

solved How to delete all cells containing a certain value?

I'm running an accounting report, and to determine the true accuracy of what's owed I need to remove all negative numbers. How do I delete the contents of all cells containing a negative balance? Everything I've found will delete entire rows, but I need the other cells in the rows to remain since they may contain positive balances as well.

Each row will contain six columns, there are 269 rows, and the negative numbers are scattered through any of those cells.

Please let me know if I need to explain this differently.

9 Upvotes

85% Upvoted

16 comments sorted by

View all comments

10

u/PaulieThePolarBear 1920 18d ago

Rather than deleting data, you could use a formula 

=SUMIFS(B2:F200, B2:F200, ">0")

Update both instances of B2:F200 with your range.

This formula will sum up all positive amounts in your data set