I have checked all the links in all the video tutorials i have for the MCE and they all work fine. If you need assistance, please comment in the specific video you fond the link and i will assist you.
Aggregate does what subtotal does and more. there is a big overlap between the 2 but subtotal is limited compared to the Aggregate in a number of ways. Subtotal offers only 11 functions compared to the 19 of Aggregate. It is not a matter of easier as this depends on preference and what you are used to using. If however you are going to learn something new then you are better off learning Aggregate.
Hello Sir. I'm preparing MCE Exam by your RUclips Video. but the download link you provided doesn't make it now. So, Would you check your link plz?
It would help if you posted your question in the comments of the video you are referring to. I have a few videos regarding the MCE Exam.
I have checked all the links in all the video tutorials i have for the MCE and they all work fine. If you need assistance, please comment in the specific video you fond the link and i will assist you.
the easiest way is to use subtotal and put 9 on the start of your formula, example =subtotal(9,A1:A13)
Aggregate does what subtotal does and more. there is a big overlap between the 2 but subtotal is limited compared to the Aggregate in a number of ways. Subtotal offers only 11 functions compared to the 19 of Aggregate. It is not a matter of easier as this depends on preference and what you are used to using. If however you are going to learn something new then you are better off learning Aggregate.