View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kelstar Kelstar is offline
external usenet poster
 
Posts: 2
Default Formula to count multiple various inputs and create a summary

Hi,

I've got a spreadsheet which has multiple rows and collums of data that I
log issues in and I need to find a way to produce a summary.

So, each row contains, status (open, closed etc) and a severity (critical,
high, etc)

I need to create a summary page which shows numbers of issues by status and
severity - e.g.

Critical High Medium Low
New 5 1
Open
Fixed 3 2
Closed
Reopen
TOTAL 5 3 3 0

Is it possible to get the summary to populate itself?