How to use MS Excel CountA & CountBlank | How to use CountA & CountBlank in Excel – Video Tutorial


How to use MS Excel CountA & CountBlank Function| How to use CountA & CountBlank Function in Excel – Video Tutorial .

########################BaatoGyan :- Share Knowledge##############################

Our Other Excel Popular Videos :-

MS Excel Shortcut Keys | Microsoft Excel Shortcut Formulas: https://goo.gl/ZxFYLE

MS Excel Shortcut Keys | Microsoft Excel ShortCut Formulas [BASICS] | MS Excel Tutorial: https://goo.gl/3MsSYU

How to use MS Excel CountIfS | How to use CountIfS in Excel – Video Tutorial: https://goo.gl/AYI2j5

How to use MS Excel CountIf | How to use CountIf in Excel – Video Tutorial: https://goo.gl/fCqUTt

How to use MS Excel Hlookup | How to use HLookUp in Excel – Video Tutorial: https://goo.gl/2Y0uO9

How to use MS Excel Vlookup | How to use VLookUp in Excel – Video Tutorial: https://goo.gl/PXCRvg

How to Create Excel Drop Down List | Excel drop down list that displays text-Tutorial: https://goo.gl/Rom9n9

########################Keep Sharing and Keep Learning##############################

=The CountA () function
Excel function COUNTA counts the number of cells in the range that does contain any value or character and returns this counted fields as the result to calculated cell. Cells that contain any text, numbers or characters are counted.

=The CountBLANK () function
Excel function COUNTBLANK counts the number of cells in the range that don’t contain any value and returns this number as the result. Cells that contain, text, numbers or character are not counted. Cells that contain formulas that return empty text (“”) are considered blank and will be counted.

Below are given scenario where employee details are given in table.

Fromula :
=COUNTA(Cell Range need to be calculated)
=COUNTBLANK(Cell Range need to be calculated)

• The syntax
The syntax for MS Function CountA & CountBlank is
= COUNTA(Range)
= COUNTBLANK(Range)
o Range – defines one or several cells to count. You put the range in a formula like you usually do in Excel, e.g. A1:A20.

############################################

#baatogyan

!!==–..__..-=-._;
!!==–..@..-=-._;
!!==–..__..-=-._;
!!
!!
!!
!!
!!
###|||###|||### ###|||###|||### Baato Gyan ###|||###|||######|||###|||###

Subscribe to Ur Baato Gyan : goo.gl/6SSedg
Facebook Page [ur like will make my day ] : goo.gl/tT6ZrF

###|||###|||### ###|||###|||### Baato Gyan ###|||###|||######|||###|||###

How To Use CountA Function,
MS Excel Function CountA,
Microsoft Office Function CountA,
CountA,
CountA Function,
Count A Function,
How To Use CountBlank Function,
MS Excel Function CountBlank,
Microsoft Office Function CountBlank,
CountBlank,
CountBlank Function,
Count Blank Function,

Video “How to use MS Excel CountA & CountBlank | How to use CountA & CountBlank in Excel – Video Tutorial” Author: Baato Gyan