Skip to main content

Advance Excel || 8) COUNTIF Function in MS Excel || Example-1

 






Advance Excel || 8) COUNTIF Function in MS Excel || Example-1.


Name
State
Sales in (Rs.)
Adrian
Gujarat
5000
Nathan
Goa
2500
John
Kerala
1250
Gerard
Haryana
1875
Zacharias
Delhi
9872
John
Tamil Nadu
7800
Fexlix
Gujarat
18700
Isaac
Gujarat
458
Kane
Punjab
22400


Example
Results
Sales over Rs. 4500
?
Sales below Rs. 4500
?
Sales by John
?
Sales in Gujarat
?








Comments

Popular posts from this blog

SAP MM (Materials Management)

  SAP Materials Management (SAP MM)- Organizational structure/ Company structure What is a MM? Materials management is  the process of planning and controlling material flows . It includes planning and procuring materials, supplier evaluation and selection, purchasing, expenditure, shipping, receipt processes for materials (including quality control), warehousing and inventory, and materials distribution. Ø    How to Start SAP server? /POWER ON (Ctrl +B) Ø    How to POWER OFF (Ctrl + E) SAP Server? Ø    How to Suspend SAP Server? (Ctrl + J) ü    ECC 6.0 Latest version of SAP server ü    ECC (Enterprise Central Components) ü    SPRO (SAP Project Reference Object) ü    IMG (Implementation Guide) ü    Ctrl + Alt + Enter (Full Screen) ü    Going back to SAP EASY ACCESS screen . /N (forward slash & N) in command window . Transactions Code (T- code) Go to Additional Information -> Additi...

Advance Excel || 5) How to create student Marksheet in Excel ? || PART -B || Using IF Condition

  Advance Excel || 5) How to create student Marksheet in Excel ? || PART -B || Using IF Condition

Advance Excel Syllabus (M S OFFICE EXCEL 2021)

  Advance Excel Syllabus   Home Menu: ·          Clipboard ·          Font ·          Alignment ·          Numbers ·          Styles ·          Cells ·          Editing   Insert Menu: ·          Pivot Table & Pivot Chats ·          Tables ·          Charts ·          Sparklines ·          Filters ·          Link   Page Layout Menu: ·          Page Setup ·   ...