Another great video! Thank you for your valued efforts in creating these. Could you make the excel sheets you created available to download? It would be great for easy access and playing along with instructions.
If you have a column which has data in certain cells but other cells are 'empty', however they still contain a formula which has returned no value, Excel will still count this as a cell using the COUNTA function. To fix this, do COUNTA - COUNTBLANK and it will only include the cells which actually have visible text rather than all cells which may not be returning values as well.
Thanks, I had forgotten about the COUNTA function. Its a real time saver. Also not sure if you covered this but COUNTA only counts something, and leaves blanks out of the count, which is often something we find useful.
Do you have the file for this example? I really appreciate your teaching and would like to try it for myself! I just don’t have a big data set. Thanks again!
What if you want to count the number of UNIQUE “segments”? For example, for rows 2-3, it is both Government. And for 4-6, it is all Midmarket. So it’s really 2 unique segments
Do conditional formating, new rule, use a formula to determine and paste the same rule in it should work. remember this only works if this rule returns true, so if it doesn't just place it within an if function =if("your rule">=0,"true","false"). I think that should help
If someone can help me with this I would be forever grateful. I use an Ipad as a log book for work. I want to highlight a certain amount of columns and get the amount highlighted shown. It just shows on the computer automatically but I would need to make an equation for it to show on the Ipad. Hopefully that made sense, any help would be appreciated!
!!!!!!!!!!!!!!!!!!!Need so help plz!!!!!!!!!!!!!!!! I want to create a simple table with numbers from A1:A10. In cell B1 I want to type the number in, and have that number automatically enter in the table in cell A1. Than when i type the second number in cell B1, i want the number from A1 to drop to A2 and have the new number go on top "A1". I want to do this each time i type a new number in cell B1. How can i create this rule????
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?
I find you as an artist in terms of delivering info to the person watches you, kindly let me know if you are on LinkedIn, would proudly like to have you in my connections
Which "previous video"??? I'm watching the beginners playlist, and not once have you covered using formulas, algebra equations...or anything on the subject.
Counta function stands for 'count anything', with Counta you can count both string and numeric values
Thanks bro
not just the way that you explain every things , even your clear & nice voice amazing too
Thank you. Not too detailed. Straight to the point and clear and concise instructions! Great job
Another great video! Thank you for your valued efforts in creating these. Could you make the excel sheets you created available to download? It would be great for easy access and playing along with instructions.
I agree! I am unable to even view them!
Thank you so much for posting videos like this! Helped me figure out an "excel/Google sheet's" riddle 😉👍🏾
A in countA probably stands for alphanumeric
If you have a column which has data in certain cells but other cells are 'empty', however they still contain a formula which has returned no value, Excel will still count this as a cell using the COUNTA function. To fix this, do COUNTA - COUNTBLANK and it will only include the cells which actually have visible text rather than all cells which may not be returning values as well.
Great information! Thanks for posting.
Thank you bro, hope you will always keep making these sort of videos.I find them really useful.God bless you bro ❤
You’re a lifesaver. I just kept getting a 0 and I was going crazy trying to find a solution. Thank you
Thank you so much! Been looking for this command for hours.
Thank you. This is exactly what I was looking for. Thank you for helping me
Thanks a lot brother. Stay blessed & Have a good day.
It was clear and helpful. Thank you!
This video is very useful and amazing explanation.
I like it, so simple and straight to the subject, keep up the good work.
Thanks, I had forgotten about the COUNTA function. Its a real time saver. Also not sure if you covered this but COUNTA only counts something, and leaves blanks out of the count, which is often something we find useful.
it is the simple things that count, thank you so much
Great video . The link for example excel file is not working which is in description. Can you correct it? Thanks.
Thank you very much for your video.I was learned something new for me.
This is very useful for me. Thank you⭐️⭐️⭐️⭐️
Do you have the file for this example? I really appreciate your teaching and would like to try it for myself! I just don’t have a big data set. Thanks again!
Here's a link to download the example file: bit.ly/excellarge . I've also added it to the video description. Thanks for watching.
Do you have any idea, how addicting these videos are?? It's 3.30 am!!!
dude, you have a problem...
@@israamuhammedasif8642 No, I'm studying bookkeeping, to prevent having problems
Bro I read your comment on 18 august 2021 at 3:30 am . This is crazy.
Really useful with clear instructions
Great explanation
Thank you bro it helped me out
Thanks for the tutorial!
You are very helpful.May god bless you
You got yourself a new subscriber with this video. 😃
Awesome, thank you!
nice explanation..
This is Helpful! God Bless you.
Is there a way to COUNTA without the first cell? Since it is usually (as in this tutorial) just a headline for data
Wow super helpful, thanks a million 🙌
What if I want to count how many Januarys are there in the sheet but with numerical format like 1/1/2022. Like how many 1s are there?
Very insightful
Very helpful 👌
You’re the best ❤thank you
Great Video!!
What if you want to count the number of UNIQUE “segments”? For example, for rows 2-3, it is both Government. And for 4-6, it is all Midmarket. So it’s really 2 unique segments
Well Explained. Thank You.
really helpful ty
how did you find that data?
What if I wanted to know how many units sold by different segments in column A?
I believe the A in COUNTA stands for active. As in active cell.
how do you use the Counta function on a filtered column so it filters to the number of records being displayed
Is there a way for count function or similar to count all cells that contain specific data?
yep its called countif i think
Could you please let me know about pivot table thanks in advance.
Thanks men.
thanks so much, but it would be nice it would be great if you make complex example,
Don't make 'em complex. I'm too stupid for that.
yeah you're right
THANKS
A LOT
Can you visualize the cells that are counted to make out the total? Like e.g. mark them with yellow marker for the ones that fit the criteria?
Do conditional formating, new rule, use a formula to determine and paste the same rule in it should work. remember this only works if this rule returns true, so if it doesn't just place it within an if function =if("your rule">=0,"true","false"). I think that should help
CountA stands for "any"
How can i count a number on cells with text in it?
Data is in other sheet, so can i use COUNTA formula in another sheet?
Thanks man
Very nice legend
Thank you so much! This is very helpful :)
how can you count the names only to get a percentage of the names?
thank you very much
That was so helpful Better than my teacher !
hello everyone where I found spreadsheets for practice? please let me know
How about counting the total number of same word.
Thanks a lot
it was every helpful :)
thanks, excel made easy
is there a way to a count that minuses hidden records?
thank you
Hi request from India to take a class on "how to edit an image (advanced) and which tool to use " . Thanks
Thanks!
Thank you so much for your kind gift! I really appreciate it.
If someone can help me with this I would be forever grateful. I use an Ipad as a log book for work. I want to highlight a certain amount of columns and get the amount highlighted shown. It just shows on the computer automatically but I would need to make an equation for it to show on the Ipad. Hopefully that made sense, any help would be appreciated!
Thanks bro the video was very helpfull in my case. May Allah bless you
Stay blessed brother
THANKS
is there a function where,
"this cell = countDRACULA(_______)"?
!!!!!!!!!!!!!!!!!!!Need so help plz!!!!!!!!!!!!!!!! I want to create a simple table with numbers from A1:A10. In cell B1 I want to type the number in, and have that number automatically enter in the table in cell A1. Than when i type the second number in cell B1, i want the number from A1 to drop to A2 and have the new number go on top "A1". I want to do this each time i type a new number in cell B1. How can i create this rule????
How do I do a CountA on a column but not have it count certain names like N/As?
Perfect! How about counting a particular occurrence lets say 'Government' in column A
Did you get a response?
Countif
A = Alpha as in alpha numeric
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?
But once i use =COUNTA i want to exlcude the headers and still run the entire column. How do i exclude a cell?
No one has an answer for this question. And this is the most important.
Thanks!!
Thank u sir
Thank you so much!
Hi everyone... How to count 2 cell value as 1..
For example
Cell 1 : Red Cell 2 : Devil
So count as Red Devil
Please help
Thanku 👍
A means 'all'
Nothing shows up on my status bar- do you know how to change that?
Your Are Amazing
Any tutorials on Corel Draw or any graphic software? I need such too.
I find you as an artist in terms of delivering info to the person watches you, kindly let me know if you are on LinkedIn, would proudly like to have you in my connections
Great...👌
in german it is count2 instead of counta
A represents alphabets
Can anyone help me I am completely confused
the functions are nothing comparing to the status bar
MAY BE A SYGNIFIES ALPHABET
Which "previous video"??? I'm watching the beginners playlist, and not once have you covered using formulas, algebra equations...or anything on the subject.
My problem is how to count A1:D2
Present !!!
I think the "A" in "COUNTA" formula means "Alphabets"🤔
Maybe A stands for Alphabet?🤔