Learn Excel & Advance Excel - Sk Excel Trick

Microsoft Office is a powerful service that helps you release your best ideas to get things done and visit associated on it is go.MS Office applications with new and enhanced features continually being added. It is Microsoft Excel spreadsheet platform that features calculation, graphic tools, pivot tables, and macro programming language support for programs commonly used in an office situation. There are various function of MS office in.

Tuesday, June 9, 2020

Excel COUNTIF Function,ms excel COUNTIF Formula

 It is COUNTIF function to count cells that meet a single criterion. COUNTIF can be used to count cells with dates, numbers, and text that chance specific criteria. The COUNTIF function supports logical operators (>,<,<>,=) and wildcards (*,?) for restricted matching.If your count any text and number in data we can.

Syntax :- =COUNTIF(range, criteria) Enter

Example Step:-

1.) RANGE - THE RANGE OF CELLS TO COUNT.

2.) CRITERIA - The criteria that controls which cells can be counted.

=COUNTIF($F$5:$F$18,H5) ENTER

* Count greater then number.

Example :- COUNTIF(H4:H14,">50") ENTER

at
Labels: ,

3 comments:

if you have any doubt let me known will
give suggestion in this site

Thank you so much

Subscribe to: Post Comments (Atom)

https://www.youtube.com/channel/UC-ydS7go5OShxe0MIeUMwUg

How to use Goal Seek in Excel for What-If analysis #sk excel trick

 How to use Goal Seek in Excel for What-If analysis #sk excel trick What-If Analysis is one of the most powerful an Excel features and one o...

https://www.youtube.com/watch?v=FHsEvT-UpDA&t=6s