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:













you can download its template from here:





Any year expense calendar


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?

 

[Joe4]

Welcome to the Board!

I do not see any negative numbers in your screen print, but I think you should be able to use SUMIF in order to sum only the negative numbers.
So that would look something like:
=SUMIF(range,"<0")

See here for more details on SUMIF: MS Excel: How to use the SUMIF Function (WS)

 

[Dhanola]

here is an example

as you can see there is negative amount now i want to add these negative amount from whole excel sheet and store it in a seperate cell anywhere but in the same sheet. AND ALSO I WANT THIS SUM TO BE OF TAKEN BY ALL THE MONTHS.

 

[Dhanola]

here is an example



View attachment 78186




as you can see there is negative amount now i want to add these negative amount from whole excel sheet and store it in a seperate cell anywhere but in the same sheet. AND ALSO I WANT THIS SUM TO BE OF TAKEN BY ALL THE MONTHS.

SO IN SEPERATE CELL WHERE THESE NEGATIVE AMOUNT WILL SUM MUST GIVE VALUE AS -220+(-40)=-260

 

[Joe4]

Just include the ENTIRE range you want to sum. Do not worry if there are text entries in it, it will just ignore those, i.e.

=SUMIF(F588:O595,"<0")

as long as you do not have any errors in the range you are trying to sum, it should work.