Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumproduct vs. countif | Excel Discussion (Misc queries) | |||
countif more than one sheet/tab and sumproduct | Excel Worksheet Functions | |||
countif, sumproduct | New Users to Excel | |||
Using COUNTIF with 2 criteria - SUMPRODUCT? | Excel Worksheet Functions | |||
SUMPRODUCT & COUNTIF | Excel Worksheet Functions |