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-expen...
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.
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)=-260
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)=-260
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.