Hello Sirs,
i have a worksheet attached herewith, there is one sheet named "Fault Status" . IN that sheet i want to have count / total of the " status" from values there against dates..
Please help me out
Thanks in advance.
Nitin
Hello Sirs,
i have a worksheet attached herewith, there is one sheet named "Fault Status" . IN that sheet i want to have count / total of the " status" from values there against dates..
Please help me out
Thanks in advance.
Nitin
In B2
=COUNTIFS(Data!$B:$B,">="&B$1,Data!$B:$B,"<"&DATE(YEAR(B$1),MONTH(B$1)+1,1),Data!$J:$J,$A2)
Copy across and down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks