Hey @Arnablaha
You can make three variables for this.
1st variable to count all the leads. [Or at the end of the flow, just add the other two variables]
2nd variable to count success leads.
3rd variable to count fail leads.
You can use a condition action, for success and failed leads. After this use increment variable action. At the end of the flow just add 2nd and 3rd variable and that will be answer to your first variable. And then store it in the excel.


Outside apply to each do this:

Expression:
add(variables('Success'),variables('Fail'))
After this step you can store these values in an excel table.