The example below should assist in what I am trying to do.
Col. A Col. B
XXX-01 8:00
XXX-01
XXX-01 9:00
XXX-02 8:00
XXX-02 9:00
XXX-02 10:00
I want to do a count where Column B has a time and Column A equals "XXX-01". The answer above should be 2. Or if I was trying to find "XXX-02" it would be 3.
Maybe something like this
in C1 and copy down
=IF(A2=A1,"",COUNTIFS($A$1:$A$6,A1,$B$1:$B$6,"<>"))
Row\Col XXX-01 XXX-01 XXX-01 XXX-02 XXX-02 XXX-02
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks