If there are data exist on the same rows of 2 columns OR there is data exist on one of the column...
If there are data exist on the same rows of 2 columns OR there is data exist on one of the column, treats it as 1 case and sum
I hope you found a solution that worked for you :)
The Content (except music & images) is licensed under (https://meta.stackexchange.com/help/licensing)CC BY-SA |
Thanks to all those great people for their contributions!
(superuser.com/users/1743669/knightvvp)knightvvp |
(superuser.com/users/1586123/johnsun)JohnSUN |
(superuser.com/users/1094459/emily)Emily |
A special thanks goes out to the (https://superuser.com/questions/1750469/if-there-are-data-exist-on-the-same-rows-of-2-columns-or-there-is-data-exist-on)Stackexchange community |
I wish you all a wonderful day! Stay safe :)
microsoft-excel worksheet-function