Prev: If 3 If's, then sum
Next: Converting PDF or HTML to Excel
From: Scott_goddard on 20 Apr 2010 11:59
Mike,

I got it to work...

=SUMPRODUCT(('(R2) Risks Log'!L9:L98="Open")*('(R2) Risks
Log'!C9:C98<>"")*('(R2) Risks Log'!L9:L98>=TODAY()-30))

I think i didnt make it clear that the variables "open" and the "date" were
in different col.....I dont quiet understand how your fourmula works...could
you explain....

"Mike H" wrote:

> Hi,
>
> Maybe this
>
> =SUMPRODUCT((C9:C98="Open")*('(R2) Risks Log'!C9:C98<>"")*('(R2) Risks
> Log'!C9:C98<=TODAY()-30))
> --
> Mike
>
> When competing hypotheses are otherwise equal, adopt the hypothesis that
> introduces the fewest assumptions while still sufficiently answering the
> question.
>
>
> "Scott_goddard" wrote:
>
> > Hi all,
> >
> > Trying to count the amount of risks the are open and and past todays date by
> > 30 days...
> >
> > So far i have
> >
> > =COUNTIF(C9:C98,"Open"'(R2) Risks Log'!C9:C98,">="&TODAY() - 7)) but i can
> > not get this to work :(
First  |  Prev  | 
Pages: 1 2
Prev: If 3 If's, then sum
Next: Converting PDF or HTML to Excel