Forum Discussion
Solved
How to sum the cells that have currencies in negative numbers only ?
Hey there I have an excel file which is in the following format:
https://ibb.co/sVx0VTL
you can download its template from here:
https://templates.office.com/en-in/any-year-expense-calendar-tm02930058
As you can see that in this we have the columns "amount" and "description". Now I want to ask if I want to sum up those cells which have negative numbers in the amount columns from the whole excel table and store only those negative amounts sum in a cell?
Same question as How to sum the cells that have currencies in negative numbers only ?
I posted a link to a workbook with a solution there.
3 Replies
- here is an example
https://ibb.co/j5JQJHC
as you can see there is a negative amount now I want to add these negative amount from the whole excel sheet and store it in a separate cell anywhere but in the same sheet. AND ALSO I WANT THIS SUM TO BE OF TAKEN BY ALL THE MONTHS.
SO IN SEPARATE CELLS WHERE THESE NEGATIVE AMOUNTS WILL SUM MUST GIVE THE VALUE AS -220+(-40)=-260Same question as How to sum the cells that have currencies in negative numbers only ?
I posted a link to a workbook with a solution there.
