Hello, I am looking for a formula that would allow me to count the number of
rows that have a date in col N6:10000 and of them are over 30 days old that
have don't have a date in col AA6:10000 which indicates that the row has been
'closed'
I was thinking i'd need an 'imput todays date' cell (though if there was not
a need for onew that would be great) and that cell is K2
I created column that gives the date of col N+30 which is col AJ
and col AI returns a 1 or 0 if the col AA has a date in it or not.
so i tried the formulas :

=COUNTIFS(N6:N10000,"*",AI6:AI10000,"0",AJ6:AJ1000 0,"today()")
Returns zero?

&

=COUNTIFS(N6:N10000,"*",AI6:AI10000,"0",AJ6:AJ1000 0,"K2")
Again returns zero?

Can anyone advise on what i am missing or if there is an easier way to
calulate this?

--
Jim

Maybe
=SUMPRODUCT(--(N6:N100000),--(N6:N10000<=TODAY()-30),--(A6:A10000=0))

Your request wasn't very clear!

--
Regards!
Stefi



€žJim€� ezt Ã*rta:

Hello, I am looking for a formula that would allow me to count the number of
rows that have a date in col N6:10000 and of them are over 30 days old that
have don't have a date in col AA6:10000 which indicates that the row has been
'closed'
I was thinking i'd need an 'imput todays date' cell (though if there was not
a need for onew that would be great) and that cell is K2
I created column that gives the date of col N+30 which is col AJ
and col AI returns a 1 or 0 if the col AA has a date in it or not.
so i tried the formulas :

=COUNTIFS(N6:N10000,"*",AI6:AI10000,"0",AJ6:AJ1000 0,"today()")
Returns zero?

&

=COUNTIFS(N6:N10000,"*",AI6:AI10000,"0",AJ6:AJ1000 0,"K2")
Again returns zero?

Can anyone advise on what i am missing or if there is an easier way to
calulate this?

--
Jim