| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif
possible reasons:
1. as far as I know COUNTIF works with open workbooks only 2. replace Network GP & PC Medicentre with Network_GP_&_PC_Medicentre 3. CTRL+` (or Tools-Options-View tab-Window options, uncheck Formulas) to switch On 29 Kwi, 09:35, Master T wrote: Greetings, I'm having a problem using countif function. I'm trying count values from two separate spreadsheet. I'm not getting any result, it returns the formula in the cell. here is the formula i'm using below =countif('[Primecure_Providers.xls]Network GP & PC Medicentre'!$A:$A,A2) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
| COUNTIF(--(),--()) help in '97 | Excel Discussion (Misc queries) | |||
| edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
![Jarek Kujawa[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
