Indirect and Address Functions in Excel
HTML-код
- Опубликовано: 1 окт 2024
- This video demonstrates the INDIRECT and ADDRESS functions in Microsoft Excel. Other functions are shown used in combination with the INDIRECT function including SUM, AVERAGE, COUNT, and COUNTIF. A1 and R1C1 styles as well as absolute and relative references are reviewed.
A1 Style??? I will google it/ Thanks for the video
How count address formula?
Hi Todd, how do you use the address function for multiple rows. Basically a Range?
Best Description on this topic stay blessed
I've followed you for a couple of years, but I never never never would have thought that I would learn excel with you! heheheh one more reason to like your channel!!! thank you for not deleting this!
nice and good job. please put all excel practiced files in the description....
FF to 9:42 for Address Function example
However, the examples show how to use the function, but there is no example of how this function would be useful. This function seems redundant, since if I want to direct a formula to calculate/refer to a cell, I could simply type $B$4, rather then use the Address function, and extra typing. Do you have an example of how the Address function would be useful?
@@tfsig I too am baffled as to why you would make it so complicated when you can simply type the cell in the sheet/tab you are interested in. I have inherited a spreadsheet from an ex-colleague who uses =@INDIRECT(ADDRESS(26,4,,,$B24) all over a multi-tab spreadsheet. It is not working correctly. So now I am trying to figure out what is wrong with it. It is really a simply spreadsheet summing the hourly rate for a particular grade of employee to their total hours. I am baffled as to why they have made it so complicated with the use of the indirect / address function. I am searching the net for coherent explanation of this function. Unfortunately, this video hasn't clarified it for me. I'll watch it again....