Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi folks,
This ought to be easy, but I can't get it to work In range J13:J110 I have various city names where a new customer has been added. There can be multiple occurances of each city as we go down the colum range of J13:j110. So there may be 5 Chicago, 2 Denver etc. In range L13:L110 I have either "Y" or Blank in front of the of the cities. I want to write a formula that for each city, it counts how many "Y" there are in range L13:L110. Any suggestions please? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
returning a count if two conditions are met | Excel Worksheet Functions | |||
count unique with conditions | Excel Worksheet Functions | |||
Count with 2 conditions? | Excel Worksheet Functions | |||
How do I count number of cels the matches 2 conditions ? | Excel Worksheet Functions | |||
Count If Formula for multiple conditions?? How To?? | Excel Worksheet Functions |