Using IF Functions with COUNTIF and SUMIF in Microsoft Excel, Slides of Fundamentals of E-Commerce

Download Using IF Functions with COUNTIF and SUMIF in Microsoft Excel and more Slides Fundamentals of E-Commerce in PDF only on Docsity!

Use of IF with other functions

COUNTIF

Count only those cells which fulfill some criterion

SUMIF

Sum only those cells which fulfill some criterion

Function Examples in

Microsoft Excel

Lookup & Reference Functions

Functions in this category implements the process of selecting a value from alist of values on the basis of some condition A large number of conditions may need to be checked (may require a verycomplex nested IF ) Example

A list of grade letters are available to be assigned in a course The selection of a grade letter will be based upon a test on the final score value. The score may need to be tested for a number of different score valuescorresponding to different grade letters. The functions useful in the scenario will be^ –

LOOKUP, VLOOKUP, HLOOKUP

Function Examples in

Microsoft Excel

Date & Time Functions

• Used to manipulate date

and time values.

TODAY( )

●

Returns a serial number which represents

today’s date. YEAR( serial_number )

●

Returns the year

corresponding to the serial number (date value) Examples

:

=TODAY()

=YEAR ( TODAY() )

Announcement:

QUIZ#

In Lecture Session # 9 (

th^

Week- 1

st^ Lecture)

Contents

Lecture slides (Lec#5 – Lec#8) Text book (Computing Essentials 2004)

Chapter 2 (spreadsheet details)

Note

Students are advised to bring

PENCILS

essentially