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)