COUNTIFS function in excel

COUNTIFS function in excel with example

The Excel COUNTIFS function returns the count of cells that meet one or more criteria means COUNTIFS can apply more than one condition at the same time.

Syntax

COUNTIFS (criteria_range1, criteria1, [criteria_range2, criteria2]…)

Arguments

range1 -      The first range to evaluate.

criteria1 -  The criteria to use on range1.

range2 -     The second range to evaluate.

criteria2 -  The criteria to use on range2.

For Example : As Shown Below In Image, Here You Can See A Table Where Store Data In Excel Spreadsheet  Related To Transition Of Amount.  Now I Want Count Transaction Type Wise (Debit Card ,Cash , Online )  This Is Our First Condition And Second Condition Is Debit Want Separate Column And Credit Amount Want Separate Column as shown Below Image.

 

1 Count All Online Debit Transaction In Cell G3

2 Count All Online Credit Transaction In Cell H3

3 Count All Cash Debit Transaction In Cell G4

4 Count All Cash Credit Transaction In Cell H4

5 Count All Debit Card Debit Transaction In Cell G5

6 Count All Debit Card Credit Transaction In Cell H5

1 Count All Online Debit Transaction In Cell G3

Formula applied G3 cell which is highlighted by yellow  background and black text color.

Formula =COUNTIFS(B3:B14,F3,C3:C14,G2)


2 Count All Online Credit Transaction In Cell H3

Formula applied H3 cell which is highlighted by yellow  background and black text color.

Formula =COUNTIFS(B3:B14,F3,C3:C14,H2)


3 Count All Cash Debit Transaction In Cell G4

Formula applied G4 cell which is highlighted by yellow background and black text color.

Formula =COUNTIFS(B3:B14,F4,C3:C14,G2)


4 Count All Cash Credit Transaction In Cell H4

Formula applied H4 cell which is highlighted by yellow  background and black text color.

Formula =COUNTIFS(B3:B14,F4,C3:C14,H2)


5 Count All Debit Card Debit Transaction In Cell G5

Formula applied G5 cell which is highlighted by red background and black text color.

Formula ==COUNTIFS(B3:B14,F5,C3:C14,G2)


6 Count All Debit Card Credit Transaction In Cell H5

Formula applied H5 cell which is highlighted by yellow background and black text color.

Formula ==COUNTIFS(B3:B14,F5,C3:C14,H2)



Post a Comment

0 Comments