Forum Discussion

Nishantu309034's avatar
Nishantu309034
Copper Contributor
Sep 17, 2020

Countif to count date getting #Error

Hi,  I am trying to count if a range of dates is greater or lesser than a particular date but facing Error. Please see the cell H11. You can check the formula in the formula bar.    Can someone he...
excel
Formulas and Functions
Rajesh_Sinha's avatar
Rajesh_Sinha
Iron Contributor
Sep 17, 2020

Nishantu309034 ,,

 

You have committed few basic mistakes.

 

  1. After the Count Range D11:D12,, COMMA is missing.
  2. Applied the operator is wrong sequence "=<",, must be "<=".

And the formula should like,,, 

 

=COUNTIF(D11:D12,"<="&$H$10)

 

 

Resources