HomeTek
New Member
- Joined
- Jan 27, 2017
- Messages
- 42
- Office Version
- 365
- Platform
- Windows
Hello. My problem is part of a more complicated Countifs formula but I have simplified it for the purposes of solving the part I am having issues with and posting it on here.
All I want to do is to count the number of cells in column H that contain a date less than the date in B1.
The formula works perfectly fine as it is in the screen print, but if I replace the static date with B1 with something such as...
=COUNTIF(H:H,"<B1")
Then the count no longer works.
The above is just an example, I have tried many different variations but I just can't get it to work with cell B1 as part of the formula.
Any help would be appreciated. Thank you.
All I want to do is to count the number of cells in column H that contain a date less than the date in B1.
The formula works perfectly fine as it is in the screen print, but if I replace the static date with B1 with something such as...
=COUNTIF(H:H,"<B1")
Then the count no longer works.
The above is just an example, I have tried many different variations but I just can't get it to work with cell B1 as part of the formula.
Any help would be appreciated. Thank you.