Forum Discussion

Drin16's avatar
Drin16
Copper Contributor
Oct 27, 2021
Solved

COUNT IF WITH MULTIPLE CRITERIA IN A MULTIPLE COLUMN ROW

Hi, How could I count specific word on multiple column and rows based on 3 criteria. Count if match with date Count if match "BAOB" Count if match "PENDING" I want to count PENDING on a speci...
excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    Oct 27, 2021

    Drin16  I assume you are working on the Dashboard tab:

    =COUNTIFS(Timesheet[Fleet],$A4,INDEX(Timesheet[#Data],,MATCH($N$3,Timesheet[#Headers],0)),C$3)
mtarler's avatar
mtarler
Silver Contributor
Oct 27, 2021

Drin16  I assume you are working on the Dashboard tab:

=COUNTIFS(Timesheet[Fleet],$A4,INDEX(Timesheet[#Data],,MATCH($N$3,Timesheet[#Headers],0)),C$3)

Resources