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.
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