Count If Formula vs Ranges

[donnajay]

Good Morning,

In a bind (as usual), I want to do a countif formula that will tell me if a persons daily productivity is under or over goal. When I type in all the days it tells me too many ranges. I have no other way to sort my file.

Any ideas?

My formula looks like this =countif(d8,d19,d25,d37,d42,d55,d61,d74,d88,d90,"<200")

there are more "d" cells in this formula

Thanks again!

 

[jasonb75]

Countif works with 1 range and 1 criteria only.

What exactly are you trying to do? Your brief description above means nothing without sample data, expected result and how you got that result.

 

[Peter_SSs]

Do you have the person's name or some identifier to those rows in another column? If so you could use something like this.

Excel Workbook
	A	B	C	D	E	F	G
7
8	Name A			150		Excel 2007+	2
9	Name B			162		Excel 2003-	2
10	Name C			174
11	Name D			186
12	Name E			198
13	Name F			210
14	Name B			222
15	Name C			212
16	Name D			202
17	Name E			192
18	Name F			182
19	Name A			215
20	Name B			162
21	Name C			152
22	Name D			2
23	Name E			56
24	Name F			89
25	Name A			22
26
COUNTIF

 

[Krishnakumar]

Hi,

May be

=SUMPRODUCT(--(D8:D90<200),--ISNUMBER(MATCH(ROW(D8:D90),INDEX(M5:M14,0,0),0)))

where M5:M14 holds the row number 8,19,25,37.....88,90

adjust the range.

 

[pgc01]

Hi donnajay

Try:

=INDEX(FREQUENCY((D8,D19,D25,D37,D42,D55,D61,D74,D88,D90),{199}),1)

I assumed the number of days is integer. If you have fractions of the day adjust the limit.

 

[donnajay]

Thank you for the suggestions! I have printed them and I will try each one to see what works!

Have a great weekend!