Hey friends in this article we will learn Excel SUM function. Using the Excel sum function you can add numbers easily without using plus sign. You can add numbers using sum function in two ways so let’s see: 1. Type =SUM(1,2) this will give you answer “3” 2. Type =SUM(A2:A3) this will give sum of …
CTRL + SHIFT +L: Do you know what is the use of this shortcut? If you know this then write your reply in the comment box. It is related to filter in excel. It can be difficult to find information quickly if your worksheet contains a lot of content. Excel Filter, is used to narrow …
In this article, we will learn about various ways to use excel filter shortcuts. Like how to apply filter, how to open the drop-down menu in excel filter etc. so let’s start… 1. How to apply Filter in Excel? In the below-given example, we will take data from a list of top billionaires. Friends when …
Copy Folder Names in Excel In excel you can learn every day something new. Today I’m sharing that I learned from the problem that I faced in excel. I got data from my team on OneDrive that contains folder names with clients bank account number, so I want that number in excel as shown below: …
Excel Sum Only Numbers ignore #N/A While working in excel you may have faced this issue that you want to do sum of column or row that contain “#N/A” due to this you can’t apply sum formula because it will throw error. Here we will understand this and solve this issue with example. Let’s Understand …