Count with various type
Thx again Jacob,
I appreciate that
"Jacob Skaria" wrote:
Try
=COUNTA(H13:H16)-COUNTIF(H13:H16,"=" & TODAY())
If this post helps click Yes
---------------
Jacob Skaria
"Pran" wrote:
I have four cells that contain
number,
text,
date,
#n/a
How can i count all four cells using counta but date only will be counted if
less than criteria that i've made <example : less than today()
Thx a lot,
|