If two criterias are met, then... With array formulas

[andy93]

Hello,
I have been lurking around this forum ,for some time now, and always found a solution for what I was looking for, and I thank you all for that.
Except for this following problem, I would need further assistance...

Examples of the formulas in C are the following: (C2): {=PRODUCT(IF(A3>B2:B$2,1,0))} and (C8) {=PRODUCT(IF(A8>B$2:B7,1,0))}
The context is that I have the open and the close of a series of stock trades. The scope is to figure out if a trade was open while another one,or many, were also open.
I display 1 if at the "Date Open" there was nothing else open
And oppositely show 0 if the open was before a previous close
_________________
Here's the twist... What I would like it to add as a condition is the following:
If the the false argument has a worth of 0 then don't consider it at all when applying the formulas.
In context it would mean that if the worth was 0 is that the trade was not actually opened so the close shouldn't influence the other trades worth.
Thanks in advance,
If you have question don't hesitate to ask.

[FDibbins]

Hi and welcome to the forum

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

[andy93]

Thank you FDibbins for the comment, I just edited the original post.