Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all
I just can't get a formula to work that will simply count how many cells match the criteria. Here's a brief section of the data: Min Week1 Week2 Week3 10 5 10 15 8 8 6 4 25 20 30 50 How do I create a formula to count by week how many have met the minimum target? The results should be 1 for Week 1, 2 for Week2, and 2 for Week 3. Bear in mind that my actual data has 52 weeks and hundreds of rows of data. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
counting with multiple criteria | Excel Worksheet Functions | |||
Counting Using Multiple Criteria | Excel Worksheet Functions | |||
counting using multiple criteria | Excel Discussion (Misc queries) | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |