I want to generate some stats from the data I have in the log tab of the excel sheet.
Of the various rows that are available, I need to find out how many belong to each 'Type'. That is, how many are 'Bug', 'Not a Bug', 'Product Issue' etc.
I am able to achieve this using the following formula (this needs to be replicated for each 'Type') -
=COUNTIF(Log!E3:E8,"Not a Bug")
However, there is one more dimension to it. I also need to categorize them based on Open and Closed issues. The Status column is used to decide that. Anything which has the status of 'Open' and 'In Progress' is deemed 'Open', while everything else (like Fixed, Closed, Verified in UAT2 etc) is deemed 'Closed'.
This is the part that I am having trouble with. Using the below formula, I was hoping to find the count of rows which have type of 'Not a Bug' and status of 'Open' (which includes 'In Progress' as well) but it returns 0
=COUNTIFS(Log!E3:E8,"Not a Bug",Log!E3:E8,"Open",Log!
Can someone please help me correct this? I am using Excel 2010.
Thanks in anticipation.