Difficult Count if Question

[Jose Miguel]

Hello All,

I have a rather hard question to pose. At every point where there is a value in column D, I want to be able to do a countif of the values in column F, with the range being the corresponding cell in F where the value is on column D to the point above the next value in column D in F. In other words, if there is a value in D1 and the next populated value is in D20, the countif should count F1 to F19. I hope this makes sense!

Thanks

Jose

 

[hatman]

How's this:

Book1
	D	E	F	G	H
1					tom
2			****
3			harry
4	1		polly
5			kelley
6			john
7			jane
8			scott
9			bubba
10			bueford
11			jethro
12			tom
13	2	1	****
14			harry
15			polly
16			kelley
17			john
18			tom
19			scott
20			tom
21			bueford
22			jethro
23			tom
24			****
25	10	3	harry
26			polly
27			kelley
Sheet3

E2 is =IF(AND(D2<>"",COUNTA($D$1:D1)>0),SUM(IF(ROW($D$1:D1)>MAX(IF($D$1:D1<>"",ROW($D$1:D1),0)),IF($F$1:F1=$H$1,1,0),0)),"") confirmed with Ctrl+Shift+Enter and copied down. Will count the number of times that the value in H1 appears in column F...

 

[barry houdini]

Hello All,

I have a rather hard question to pose. At every point where there is a value in column D, I want to be able to do a countif of the values in column F, with the range being the corresponding cell in F where the value is on column D to the point above the next value in column D in F. In other words, if there is a value in D1 and the next populated value is in D20, the countif should count F1 to F19. I hope this makes sense!

Thanks

Jose

What sort of values do you have in column D, numbers or text? What do you want to count in column F?