dcount

  • Thread starter Thread starter michaeldmaxey
  • Start date Start date
M

michaeldmaxey

i am trying to have a criteria that one cell is greater than or equal to a
date but i want the date to reference another cell. For instance >=B3
(greater than or equal to the date located in cell B3). The criteria works
if i write >=7/31/09 but i want the date to refer to another cell where i can
change that date one time.
 
I am not clear whether this is what you are looking for…

A1 Date is greater than or equal to B1and if you want to display the C1 cell
value then use this formula:
Use this formula other than A1,B1 & C1 cell
=IF(A1>=B1,C1,"")

If you want to use the date value in the formula itself then use the below,
It will check whether the A1 Date Value is greater than or equal to the
mentioned date value and return the C1 value.
=IF(A1>=DATE(2009,7,31),C1,"")

If this post helps, Click Yes!
 
Try:

=">="&b3

ps. Excel has some nice features that 123 doesn't (didn't???) have.

One of them is =countif()

=countif(a1:a10,">="&b3)

maybe sufficient.

xl2007 added another function (=countifs()) that allows multiple criteria for
multiple fields.

There are also =sumif() and added in xl2007, =sumifs().

In earlier versions of excel, =sumproduct() or an array formula =sum(if(..)) may
do what you want.
 
Back
Top