Hello Sir! How can I count No. of Present Mark in a week (From Monday to Saturday) on weekly basis for the whole month using formula and not using VBA.
HELLO SIR ,THANK YOU FOR MAKING EXCEL FUN !!! MAY I REQUEST YOU DO VIDEO ON HOW TO SUM UP DATA FROM MULTIPLE WORKSHEETS using Sumproduct, sumif and indirect formulars thank you
Turned out very helpful for me but I've one query suppose i wanna count the values lying in a data array, in a specific given range how do i do that? Please reply and guide if possible for you🥺
Sir, can you help me with one query? I have once date (08th Aug'22) and I need to know what will be the future date after specific number of days (7 days) also taking weekends into consideration.
I have a spreadsheet where I want to keep track of a number in a lot of cells and how many times the number appears. Also When the number appears i want it to go back to 0 and start the count again until the number pops back up. Can excel do that?
hello sir, i have a question, whenever i write after the select range like you wrote Apple you have got the answer but i get always 0. why? i can not write in any formula i have to select the cell
Thanks for making Excel cheap. I am working on a project and got stucked . Need a one on one tutelage. I am ready to commit myself financially. How do i get starting with you? Would be glad to read from you. Respectfully.
Doubt- Oce we use "countblank" function on a large dataset and found that there are suppose 3 cells which are empty. How can I go directly to those cells which it has counted just to verify that I have left them blank knowingly or some data got deleted by mistake? It'll be very useful if you can answer this doubt.
Hi bro I have data date wise sales and purchase I need you are support in excel when IAM enter specific any date I need that date how many sales and purchase happen I require counts like I use today date I required 100 sales and purchase 50 like Wich formula I need to use
Hello sir now i have one Q for you help: i have date in excel is 1- A,B,A,C,G 2- A,B,A,C,G 3- A,A,C,G 4- A,B,C,G i want count 1to4 have A how much ? please help me too
Sir I like your video too much . Sir I have one problem. I have 5 value like, 15,20, 8,9,5. In this I want to count value which less than 10 and greater than 15 . How count formula is apply
Can someone solve this please? If I Enter 500 How to enter formula to display. 30. 70. 100. 100 100 row wise using IF Formula 1-30 ---. 30 31-100 --- 70 101-200--- 100 201-300--- 100 301-400--- 100 Above 400