( by Rashi Gadia )
Have a look at the following screenshots of my spreadsheet:
Sheet 'Bug Report':
I have the following formula in Cell A1 of sheet2:
=query('Bug Report'!A:C;"select A,B,count(C) where A<>'' group by A,B label count(C) '' ")
the above formula will give you the group by results from Sheet 'Bug Report'.
You can also put the above formula on any other sheet.
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.