How to sum the cells that have currencies in negative numbers only ?

[Dhanola]

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?

[#2]

@Dhanola 

=SUMPRODUCT(($B$2:$B$24=D2)*($A$2:$A$24<0)*$A$2:$A$24)

You can try SUMPRODUCT. 

[#3]

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

[#4 · Accepted solution]

@Dhanola 

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.