Countif based on relative cell

Ok so I have this forumula in a cell:

=SUM((COUNTIF(F7:F69,"<=" & TODAY())),(COUNTIF(B7:B69,">=" & D7)))

and the trouble I am having is that in the second Countif, I need it to check the cell in the "D" column relative to what cell is being checked in the "B" column. Right now it is checking every cell in "B" against "D7" instead of "D8, D9, D10", according to what cell in "B" is selected.

Any help would be appreciated.

that didnt work, just gave me a 0. i tried using D7:D69 in my original formula but it didnt work

i want the Countif to check cells B7 thru B69, and count if the relative cell in the "D" column is greater than or equal to the cell in the "B" column

yeah its basically taking the two Countif's and adding them together.

Originally Posted by NBVC

Ok try:

=SUMPRODUCT(--(B7:B69>=D7:D69))

what about the dates in F? Is that a separate count?

that didn't work either.

ok it worked. thanks a bunch

Hi All, I'm having something similar to solve so I don't want to start a new thread.
What I need to do is: "count all occurences of cell value in Column A + cell value in Column B in the corresponding row is larger than 1000".
In the logical sense, what I'd need is COUNTIF(A1:A100+B1:B100>1000) - but this doesn't work with two columns.
I've seen other posts with comparing columns and count them based on criteria, but I haven't found any that shows me how to do countif based on sum of two columns...
Any help is greatly appreciated.