| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CountIf on not number values. How can I solve?
Thank you Rick.
"Rick Rothstein" wrote: If I understand your layout correctly, you can do something like this to count all of the, say, American Leaves... =SUMPRODUCT((B2:B200="American")*(C2:IV200="L")) where the 200s need to be a number large enough to cover the maximum row number you ever expect to have data in. You can also adjust the IV column reference to the actual maximum column you ever expect to have data in. To get any other statistics, just change the "American" and the "L" to what you are looking for. -- Rick (MVP - Excel) "Nicola M" wrote in message ... Hi all. Excel 2003. I need to count not number values using criteria. In the cell to count I have letters (like A, L, R etc stands for Absent, Leave, Rest etc). THis count is to be for nation and I have nationalities in unsorted order in an other cell. I can't use CountIf because cells don't contain number thought the nation criteria is respected with this function. Using Count or COuntA I count correctly the values but without the nation criteria. Even Using VBA is there a way to solve this issue? My sheet headers are on row 1. Data starts from Row 2 with the following structu A= Surname and Name; B= Nationality; C to n= Days number Thanks in advance for every kind of help or suggestion and for my non perfect English. Nicola M. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Solve 1st of month after specified number of days elapsed | Excel Worksheet Functions | |||
| how to solve this by countif | Excel Worksheet Functions | |||
| excel doest not shows the number starting with 0..is there is any way to solve this. | Excel Discussion (Misc queries) | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| Countif between two values | Excel Worksheet Functions | |||
Hybrid Mode
