Forum Discussion
Solved
Help with formulas based on criteria
I have a Stock Options workbook with several sheets and I'm looking for a formula that will draw info from some of the sheets into a Summary page. For instance, I have one sheet titled ProfitGrid wh...
Paladin1078 Yes, attachments are available not for all users. You may share your file on OneDrive, Google Drive, whatever. Give access to everyone and share the link.
Here's a much simpler spreadsheet. I simply want Excel to search the A column of the Puts, Calls, etc page for the ticker symbol in the A column of the ProfitGrid page and report the profit or loss from the AF column of the Puts or Calls page IF the AK column for the Puts page contains anything other than "Open" and report that total in cell B4 of the ProfitGrid page. Or, in the example of the calls page if the report the results in cell C4 of the ProfitGrid page. In the example sheet there is just data for a few trades but, in the real sheet there would be hundreds of trades. https://1drv.ms/x/s!AgkZn08NrdddlE7gUkiQvPU2nQve?e=zj1IEv
Okay, thank you.
That could be
=SUMIFS(Puts!$AF:$AF, Puts!$AK:$AK, "<>Open", Puts!$A:$A, $A4 )in B4 and drag it down, similar for Calls. Please check in attached.
- YES! Exactly! Thanks so much.
Paladin1078 , you are welcome