G
Guest
THIS IS MY FORMULA
=SUMPRODUCT((--(INDIRECT($C$5&"!$e$1:$e$5000")>36000)*(--(INDIRECT($C$5&"!$D$1:$D$5000")<>"Threat found!"))))
e1:e5000 is date
d1:d5000 is for expression, where mostly statement "Threat found!" will be
there.
Now I need to get count of records where there is date in e1:e5000 and
where there is no string expression "Threat found!"
The above formula is counting the title in e1 "Definitions" and in future I
may have some other string between e1:e5000, I need to validate only dates
between e1:e5000. I have put >36000 thinking that I can omit other than date
but "definition" value turns out to be true, so it is taken in to count
Kindly advise and thanks in advance.
=SUMPRODUCT((--(INDIRECT($C$5&"!$e$1:$e$5000")>36000)*(--(INDIRECT($C$5&"!$D$1:$D$5000")<>"Threat found!"))))
e1:e5000 is date
d1:d5000 is for expression, where mostly statement "Threat found!" will be
there.
Now I need to get count of records where there is date in e1:e5000 and
where there is no string expression "Threat found!"
The above formula is counting the title in e1 "Definitions" and in future I
may have some other string between e1:e5000, I need to validate only dates
between e1:e5000. I have put >36000 thinking that I can omit other than date
but "definition" value turns out to be true, so it is taken in to count
Kindly advise and thanks in advance.