How to count rows if greater than date?

**jgomez** · 07-12-2011, 12:49 PM

Hi there, I got this formula:

=COUNT(--('Commercial Loans'!I3:I1200),--(E3<'Commercial Loans'!I3:I1200))

I want to count the number of rows that have a date greater than today(E3). For some reason I get 2 as a result when it should be 732. Not sure what I missed or did wrong.

Thanks in advance!

**Colin Legg** · 07-12-2011, 12:51 PM

Hi,

I want to count the number of rows that have a date greater than today(E3).

=COUNTIF(Commercial Loans'!I3:I1200,">"&E3)

**jgomez** · 07-12-2011, 01:15 PM

It worked but do you mind if i ask why the "&" I don't get that part...

**jgomez** · 07-12-2011, 01:35 PM

Didn't want to start a new thread over soemething similar...

=SUMIF('Commercial Loans'!J3:J1200,"Off",'Commercial Loans'!J3:J1200)

This formula is supposed to count anything on column J that contains Off... it can be Off, off/AL, John/off... its returning zero though.