| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif with non-continous ranges
Hi all, I'm reading this site and am really impressed with the knowledge. I'm
hoping I can get a simple answer for a simple mind. I am just learning formulas so much of what I see for answers I just don't truly understand. Here is the formula I have set up. What I am trying to do is count U5:U10 + U12:U17. I do actually get the correct results with this following set up, but I just think I'm being lucky. I can get the set up work correct in the CountA function, but not the CountIF... =COUNTIF(U5:U10:U12:U17,"3.028")/COUNTA(U5:U10,U12:U17) Thanks so much for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF using # ranges, and referencing 2 other columns | Excel Worksheet Functions | |||
| COUNTIF with multiple disjoint ranges, same criteria | New Users to Excel | |||
| COUNTIF with multiple disjoint ranges, same criteria | New Users to Excel | |||
| Countif between ranges | Excel Discussion (Misc queries) | |||
| COUNTIF criteria using date ranges? | Excel Worksheet Functions | |||
Threaded Mode
