Number of rows over 30 days after creation

J

Jim

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:AJ10000,">today()")
Returns zero?

&

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

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

Stefi

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

Your request wasn't very clear!

--
Regards!
Stefi



„Jim†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help formatting rows of text within a single cell 0
SumIf across columns instead of rows 3
Obtaining Forward EndDate with StartDate and Number of Days e.g. 30 (Number of days(30) excludes wee 1
Running total over a find number of days 12
Print variable number of rows of spreadsheet 1
Number of days 2
formula to count number of months that have passed 5
Counting number of days up to an empty cell then start over again 1

Top