Hello,
please help me to add only negative values from a large database.
I have losses in shops and I want to know how much is the total loss out of all the shops.
Thanks
Hello,
please help me to add only negative values from a large database.
I have losses in shops and I want to know how much is the total loss out of all the shops.
Thanks
Is this really an Outlook query, or an Excel one?
Assuming your sum data is in column C, Try this:
=SUMIF(C:C,"<"&0,C:C)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Excel 2016 (Windows) 64 bit
A B 1Data Result 2 -3 -62 3 -6 4 7 5 8 6 -9 7 5 8 1 9 0 10 -3 11 10 12 -2 13 -10 14 8 15 -3 16 6 17 -9 18 -5 19 6 20 8 21 -3 22 6 23 -9
Sheet: Sheet1
B2Formula:Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
SUMIF is enough for this - no need for SUMIFS unless there are multiple criteria.
Glad to see you using your new 'toy'!
It works,
thanks a lot.
Ma'am you are absolutely correct.
Heheh Lolzz Yes I am and so happy to get it
it works, thanks
Multiple criteria?
Hmmm.... I always can figure out one.
lets, say >0 ; >1000
Can I use multiple criteria looking in different columns?
Yes you can do. Here below mention link is description about Sumifs function.
https://exceljet.net/excel-functions...umifs-function
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks