View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
numbernine numbernine is offline
external usenet poster
 
Posts: 4
Default 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