You can create an attendance report by House. Go to; Reporting> Reports>Attendance (red tab)> Attendance by House.
Select the date range you need and click "Choose." You can also tick here if you want to include former students in the report.
This report will give you individual student attendance statistics in each House, with totals for overall House attendance figures.