Countif Question

[MarkAndrews]

I have the following data table which is set to be filled in today

However - I would like to impliment this countif

=COUNTIF('Paste IQ Report Here'!A:A,"a1*")

The problem lies - "a1*"

I know Countif can be modified to look for certain words, which is what i'm after, the certain word exists in A1 (a pre entered list of names)

Is there a way to adapt?

TIA

Book1
	A	B	C	D	E	F	G	H
1	FeeEarner	Level	REMorSAP		Actual	AuthactYes	AuthactNo	CapacityVariance
2	MarkAndrews	3	REM		0	80	-80	#DIV/0!
Sheet2

 

[Richard Schollar]

Maybe:

=IF(Results!A2="","",COUNTIF('Paste IQ Report Here'!A:A,"*" & Results!A2 & "*"))

Richard

 

[MarkAndrews]

I'll give it a try Richard, thanks again