A report answers one question about one kind of record: how many deals in each stage, how much open pipeline each rep owns, the average deal size by deal type. Build it in Reporting > Reports: pick the data source (contacts, companies or deals), the measure (count of records, or the sum or average of a number property), what to group by, and any filters.
Count and sum answer different questions. Ten small deals and one large one count as eleven but add up to whatever the amounts say; a manager asking about "pipeline" almost always means the sum of Amount.
Records with an empty group property land in a (No value) group. Don't hide it: its size tells you how much of the data is incomplete. An average leaves out records with no value in the averaged property, so check how many that is.