Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT IF WITH 2 CRITERIAS WITH SEVERALS ITEMS ON EACH CRITERIA
Hi, I have this problem
Problem: I want to count in how many differents incidents each location took part of. In each incident a location can participate many times. I have the info like this, INC LOC 1 A 1 A 1 B 1 C 1 B 2 B 2 D 2 D For example, the results in this example is A: 1. (Participate only in incident 1, it makes no different how many times it does inside that incident, I don´t need that info ) B: 2. (incident 1 and 2) C: 1. D: 1. I cannot do it with a pivot table, because when counting it will count also the times within each incident. Also, when using Index, it won´t count the total. The problem with the sumproduct functions is that I have several incidents and several location, that also aren´t fixed. They change. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Filtered Visible Items that Match Numeric Criteria between two ranges | Excel Worksheet Functions | |||
Count items when specific text and date criteria are met | Excel Worksheet Functions | |||
How can I count items in multiple columns with different criteria. | Excel Worksheet Functions | |||
Count of items using multiple criteria | Excel Worksheet Functions | |||
Find Count of Items with certain criteria | Excel Discussion (Misc queries) |