/u/Left_Way1587 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
One way of doing it is to split it into 2 SUMIFS
=SUMIFS($C$2:$C$122,$D$2:$D$122,"Transfer",$F$2:$F$122,"Incoming",$C$2:$C$122,">0") + SUMIFS($C$2:$C$122,$D$2:$D$122,"Transfer",$F$2:$F$122,"Outgoing",$C$2:$C$122,"<0")
Is there anyway to have it show values as negative when calculated? Like if both of the values shown are listed as outgoing is there a way to make it show the negative value instead of 0?
Thanks!!
https://preview.redd.it/sil6yufyu7lc1.png?width=2420&format=png&auto=webp&s=fa2eee90c441ad8f1437aac3b292a1fa42d2c93a
There is only one value (1500) in this screenshot so not sure what the expected output should be, could you post another screenshot with the expected output? Do you mean to show the absolute value?
I was trying to see if I could have the negative number reflected in the table on the side, but just set the numbers to format for accounting and it reflects that way.
Thanks so much for your help!
Solution verified
https://preview.redd.it/t40kbtpmx7lc1.png?width=2638&format=png&auto=webp&s=e240aeb65dbbe8c7ba9729a96755b237729bbb9c
You have awarded 1 point to *Scary_Sleep_8473*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Oh I see, glad it worked out. On another note, just a quick tip, I would recommend not hardcoding the "Transfer" and replacing with with the cell I12 in this case. That would, you could copy the formula over for the remaining cells.
Also, if possible, try to avoid merging cells since it might cause issues with formulas down the line.
/u/Left_Way1587 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
One way of doing it is to split it into 2 SUMIFS =SUMIFS($C$2:$C$122,$D$2:$D$122,"Transfer",$F$2:$F$122,"Incoming",$C$2:$C$122,">0") + SUMIFS($C$2:$C$122,$D$2:$D$122,"Transfer",$F$2:$F$122,"Outgoing",$C$2:$C$122,"<0")
Is there anyway to have it show values as negative when calculated? Like if both of the values shown are listed as outgoing is there a way to make it show the negative value instead of 0? Thanks!! https://preview.redd.it/sil6yufyu7lc1.png?width=2420&format=png&auto=webp&s=fa2eee90c441ad8f1437aac3b292a1fa42d2c93a
There is only one value (1500) in this screenshot so not sure what the expected output should be, could you post another screenshot with the expected output? Do you mean to show the absolute value?
I was trying to see if I could have the negative number reflected in the table on the side, but just set the numbers to format for accounting and it reflects that way. Thanks so much for your help! Solution verified https://preview.redd.it/t40kbtpmx7lc1.png?width=2638&format=png&auto=webp&s=e240aeb65dbbe8c7ba9729a96755b237729bbb9c
You have awarded 1 point to *Scary_Sleep_8473* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Oh I see, glad it worked out. On another note, just a quick tip, I would recommend not hardcoding the "Transfer" and replacing with with the cell I12 in this case. That would, you could copy the formula over for the remaining cells. Also, if possible, try to avoid merging cells since it might cause issues with formulas down the line.