Speculation of shares

If trades are from intraday then purchase and sale value is irrelevant.
What you need to do is calculate profit and loss on each trade individually (without considering brokerage and other COA expenses)
Now you need to ignore negative value from all loss trades and sum it up
In excel this can be done easily using ABS Formulae

Yes, tax audit is applicable.