CountIf or Sumproduct
hi
i got a problem with function Countif and sumproblem
My problem is that i need to match 3 diff critieria , if all of them matches
, on a cell , it will count 1 .
1st spread sheet
Date Status Place
010906 Accepted L.A
010906 Accepted L.A
010906 Pending L.A
020906 Accepeted chiago
If the date is "010906" , then the status is either accepted or pending and
the place is L.A . i wan the cell below to count , how to i do that ? do i
need to create a dummy column ?
2nd spread sheet
place 010906
L.A 3
|