title: count sum of rows in multiple excel files using PYTHON
body: <p><strong>PART 1)</strong> I have <strong>multiple</strong> <em><strong>XLXS</strong></em> excel files saved in a folder path:</p>
  <p><em><strong>File Name   Row count</strong></em>
  Excel 1     10
  Excel 2     20
  Excel 3     10
  Excel 4     10
  Excel 5     5</p>
  <p>Each XLXS file contains the <strong>SAME columns eg: Name, Postcode, Address, Number</strong></p>
  <p>Each has a <strong>different row count</strong>:</p>
  <p>I need a quick way to <strong>COUNT and SUM</strong> all the rows in these 5 Excel files on PYTHON. (I have done it manually and I have never used Python and need to do this on Python)</p>
  <p>Desired output should be:</p>
  <p>Total Count= 55</p>
  <p><strong>PART 2)</strong>
  Now that I have the total count I need to COMPARE the count of the records to ensure they are the SAME in another seperate **** File (combined 5 xlxs files) -</p>
  <p>it should both match to 55 rows</p>