If Then Count Data in Range

[jonisanders]

I know this is probably easy and I had it working once but when I sorted the data I received FALSE in my result cell.

What I want to do is this:
if a cell in a range (a2:a101) equals to X then count the instances of data entered in (c2:e101).

 

[schielrn]

Maybe something like?

=if(countif(a2:a101,"X"),counta(c2:e101),"No X Found")

Not sure what you mean by count the instances of data entered, but I assume you mean count any cell with something in it?

Hope that helps.

 

[jonisanders]

Yes. Any instance with data in it.
What I have is =IF(COUNTIF(A2:A101,"Jon Doe"),COUNTA(C2:E101))

This is counting all instances of data entry in C2:E101 not just the ones associated with Jon Doe.

Any suggestions?

 

[schielrn]

So you are only wanting to count data on the rows that have john doe in column A?

 

[jonisanders]

Yes.
Thank you for your assistance.

 

[schielrn]

How about this:

Excel Workbook
	A	B	C	D	E
9	5
10
11
12	john doe		d		s
13
14
15	john doe		s	s
16
17
18
19	john doe		0
20
21
Employees

#VALUE!

Entered with Ctrl+Shift+Enter

Change cell references to what you need. Notice it is an array formula and needs to be confirmed with control+shift+enter and not just enter.

Hope that helps.

 

[jonisanders]

Thanks so much. Took me a while to get it going cause I kept forgetting about entering the array but it works great now.
Thanks again.