1. Simply click on the next cell of column where you want the sum. 2. Press Alt and = keys together. 3. It will show the sum and range of sum. 4 Click Enter key and you will get sum of the column.
Hi,Most of us know that using Vlookup function we can get the right column values, however by using Choose function in Vlookup table array, we can pull left column values as well. In the below screenshot...
A B C D 1 NAME PRODUCT NAME TOTAL AMOUNT 2 SAURABH WASHING MACHINE 4165 3 MANIPAL MI PHONE 4803 4 ANJALI SAMSUNG MOBILE 4610 5 UMA NOKIA PHONE 4441 6 SHANKER T.V 3765 7 NARESH ...
I would like to share my experience of how Indirect formula helped me in my recent project. I was working with some report which was connected to a large database in excel, so whatever changes I made to...