![]() |
|
#1
|
|||
|
|||
![]()
I have 2 spreadsheets set up, one called caseloads and one called pipeline.
Basically there is one sheet on the caseloads workbook for each person. What i want E7 to do is count how many times that persons name appears on the pipeline workbook in column A. Anyone have any ideas how to do this? To make it easier the pipeline workbook is currently called Book1 I hope this all makes sense |
#2
|
||||
|
||||
![]()
Perhaps try the COUNTIF function?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
![]()
I tried a countif, but that still did not seem to work
the formula is the below, i have replaced the name below with %%% =COUNTIF("[Book1.xlsx]Sheet1!$A:$A","%%%") This does not work and comes up with this error - The formula you typed contains an error. - For information about fixing common formula problems, click Help. - To get assistance in entering a function, click Function Wizard (Formulas tab, Function Library Group). - If you are not trying to enter a formula, avoid using an equal sign (=) or minus sign (-), or precede it with a single quotation mark ('). |
#4
|
||||
|
||||
![]()
Is the other workbook open?
Are you sur about the double quotes around the range?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
![]()
i'm not too sure, i'm using the function wizard for the COUNTIF, and it seems to automatically be doing that
|
#6
|
||||
|
||||
![]()
Try single quotes like
Code:
=COUNTIF('[Book1.xlsx]Sheet1'!$A:$A,"%%%")
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
cadonn | Excel | 9 | 09-02-2014 02:06 PM |
![]() |
d4okeefe | Word VBA | 5 | 11-11-2013 11:02 AM |
How to enter names in Resource Pool/names | pstein | Project | 1 | 03-26-2012 07:37 AM |
Auto Entry Names etc Into Document | simonyglog | Word | 2 | 07-08-2010 10:22 AM |
Printing document with style names | Steve_D | Word | 0 | 12-10-2009 09:23 PM |