Using Count and CountA in Excel - Excel Tutorial

[mohammadadnan]

not just the way that you explain every things, even your clear & nice voice amazing too

[gulsahtanay]

Counta function stands for 'count anything', with Counta you can count both string and numeric values

[coreenrogers]

Thank you so much for posting videos like this! Helped me figure out an "excel/Google sheet's" riddle 😉👍🏾

[ahsanulhaquefahim]

Thank you bro, hope you will always keep making these sort of videos.I find them really useful.God bless you bro ❤

[davidgallant]

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.

[wolfmanj]

Thank you. Not too detailed. Straight to the point and clear and concise instructions! Great job

[bridgerpetersen]

You’re a lifesaver. I just kept getting a 0 and I was going crazy trying to find a solution. Thank you

[burak]

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.

[jm-lmxd]

I like it, so simple and straight to the subject, keep up the good work.

[crackerjackcarnivore]

Great information! Thanks for posting.

[bballjones]

A in countA probably stands for alphanumeric

[galileemangala]

Wow super helpful, thanks a million 🙌

[zhuan]

That was so helpful Better than my teacher !

[shipsnaps]

Thank you so much! Been looking for this command for hours.

[anuakshay]

You are very helpful.May god bless you

[contrastOG]

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.

[TimmysTreats]

Thank you. This is exactly what I was looking for. Thank you for helping me

[shaqueal]

it is the simple things that count, thank you so much

[merainietupay]

Thank you so much! This is very helpful :)

[Umairsajid]

Thanks a lot brother. Stay blessed & Have a good day.