Thanks for the very informative video. Besides indirect function, I learned another way of cell referencing. The indirect function appears like a catalyst. It doesn't work by itself, but it makes other functions work easily.
Awesome! We're thrilled that you found the video helpful and learned about another way to reference cells. Keep up the great work! 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! TH-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► th-cam.com/users/simonsezittraining ♥️ We appreciate your support! #SimonSezIT #Excel
I really appreciate your help, thank you very much! On my excel I have Purchase & Sale column together. Purchase can be in cash & in Credit & also the same way Sale can be in cash & in Credit. Now I need to get total credit in purchase & total credit in Sale. The same to credit for sale. Can I do this with this function?? Or shall I send you please?
Can you use this function in CRM ( One to Many) . i.e. I have several worksheets. One is the records of many Customers ( Companies), the second Contacts ( All employees who are working in each Company), third Invoice records. Each company may have zero to 100 invoices, forth sheet for all work orders (Each company may have zero to 100). The using Data Validation and Combo Box to select a company in a new sheet and upon doing this to see certain columns from other sheets. ( Name, Title, Email & Phone of its contacts), (Date, Invoice Number, Product, Value,..) from Invoices, same goes for Work orders and any other sheets. I would appreciate your input. Thank you
=INDIRECT("R9C"&COUNTA(9:9);FALSE) When I work within one excel sheet that function works perfect but if I'd want to display this in another document? How to corectly link that ?
Is this a function I can use to reference a cell containing the name of another sheet in the same workbook? More to the point, I'd like to display the value of a cell in a sheet that I'd name in the reference cell.
Thanks for the very informative video. Besides indirect function, I learned another way of cell referencing. The indirect function appears like a catalyst. It doesn't work by itself, but it makes other functions work easily.
Awesome! We're thrilled that you found the video helpful and learned about another way to reference cells. Keep up the great work! 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
#SimonSezIT #Excel
clear and concise explanation. Thank you
Good explanation of using indirect function in getting the sum total in a different cell using condition
Thank you Shabeen
You make excel so Easy.
Glad you think so!
crystal clear explanation for Indirect Function!!!!!
Glad it was helpful!
Useful, clear explanation. Thank you
You're welcome 😊 Thanks for watching!
Superbly explained. Thanks!!!
Glad it was helpful!
Thanks for the Tutorial on Indirect Function in Excel. 1st Like ❤️.
Thanks for liking
I really appreciate your help, thank you very much! On my excel I have Purchase & Sale column together. Purchase can be in cash & in Credit & also the same way Sale can be in cash & in Credit. Now I need to get total credit in purchase & total credit in Sale. The same to credit for sale. Can I do this with this function?? Or shall I send you please?
appreciated. Thanks
Can you use this function in CRM ( One to Many) . i.e. I have several worksheets. One is the records of many Customers ( Companies), the second Contacts ( All employees who are working in each Company), third Invoice records. Each company may have zero to 100 invoices, forth sheet for all work orders (Each company may have zero to 100). The using Data Validation and Combo Box to select a company in a new sheet and upon doing this to see certain columns from other sheets. ( Name, Title, Email & Phone of its contacts), (Date, Invoice Number, Product, Value,..) from Invoices, same goes for Work orders and any other sheets. I would appreciate your input. Thank you
=INDIRECT("R9C"&COUNTA(9:9);FALSE)
When I work within one excel sheet that function works perfect but if I'd want to display this in another document? How to corectly link that ?
Your English accent sounds great. May I know where is it from
England ;-)
Is this a function I can use to reference a cell containing the name of another sheet in the same workbook? More to the point, I'd like to display the value of a cell in a sheet that I'd name in the reference cell.
Bali is not a country. It's a province of Indonesia.
Bali is not a country