| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count entries in a range that match a certain criteria within datavalidation.
Hi,
On cells D1:D50, each cell has a list of several options to choose. (Used Data-Validation-Allow-List, Source="Apple, Orange,Grape,Nop- Apple,Nop-Orange,Nop-Grape") So on each cell I can choose of the options available in the source field. I need to be able to count all the cells in the range D1:D50 that contain the first three letters "Nop" I tried Sumproduct function but it either gives zero or a #value error and countif if using it like this : =COUNTIF(D1:D5, "=Nop-Apple"), but I want something like this =COUNTIF(D1:D50, LEFT(D1:D50,3)="Nop")) which of course doesnt work Can someone help with this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count if two columns match different criteria | Excel Worksheet Functions | |||
| Count of entries meeting criteria | Excel Worksheet Functions | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| I Need to Count Number of Entries Based on Two Criteria | Excel Worksheet Functions | |||
| count no. of entries in range for a day | Excel Worksheet Functions | |||
Threaded Mode
