Countif Query

[Sourav H]

[TABLE="width: 258"]
<tbody>[TR]
[TD]Find from the below table 1. January and February sales
[/TD]
[/TR]
[TR]
[TD]2. January OR Brooks OR Amount > 1000
[/TD]
[/TR]
[TR]
[TD]
3. January sales for Brook or Cook[TABLE="width: 418"]
<tbody>[TR]
[TD]Month
[/TD]
[TD]SalesRep
[/TD]
[TD]Type
[/TD]
[TD]Amount
[/TD]
[/TR]
[TR]
[TD]January
[/TD]
[TD]Albert
[/TD]
[TD]New
[/TD]
[TD="align: right"]85
[/TD]
[/TR]
[TR]
[TD]January
[/TD]
[TD]Albert
[/TD]
[TD]New
[/TD]
[TD="align: right"]675
[/TD]
[/TR]
[TR]
[TD]January
[/TD]
[TD]Brooks
[/TD]
[TD]New
[/TD]
[TD="align: right"]130
[/TD]
[/TR]
[TR]
[TD]January
[/TD]
[TD]Cook
[/TD]
[TD]New
[/TD]
[TD="align: right"]1350
[/TD]
[/TR]
[TR]
[TD]January
[/TD]
[TD]Cook
[/TD]
[TD]Existing
[/TD]
[TD="align: right"]685
[/TD]
[/TR]
[TR]
[TD]January
[/TD]
[TD]Brooks
[/TD]
[TD]New
[/TD]
[TD="align: right"]1350
[/TD]
[/TR]
[TR]
[TD]January
[/TD]
[TD]Cook
[/TD]
[TD]New
[/TD]
[TD="align: right"]475
[/TD]
[/TR]
[TR]
[TD]January
[/TD]
[TD]Brooks
[/TD]
[TD]New
[/TD]
[TD="align: right"]1205
[/TD]
[/TR]
[TR]
[TD]February
[/TD]
[TD]Brooks
[/TD]
[TD]Existing
[/TD]
[TD="align: right"]450
[/TD]
[/TR]
[TR]
[TD]February
[/TD]
[TD]Albert
[/TD]
[TD]New
[/TD]
[TD="align: right"]495
[/TD]
[/TR]
[TR]
[TD]February
[/TD]
[TD]Cook
[/TD]
[TD]New
[/TD]
[TD="align: right"]210
[/TD]
[/TR]
[TR]
[TD]February
[/TD]
[TD]Cook
[/TD]
[TD]Existing
[/TD]
[TD="align: right"]1050
[/TD]
[/TR]
[TR]
[TD]February
[/TD]
[TD]Albert
[/TD]
[TD]New
[/TD]
[TD="align: right"]140
[/TD]
[/TR]
[TR]
[TD]February
[/TD]
[TD]Brooks
[/TD]
[TD]New
[/TD]
[TD="align: right"]900
[/TD]
[/TR]
[TR]
[TD]February
[/TD]
[TD]Brooks
[/TD]
[TD]New
[/TD]
[TD="align: right"]900
[/TD]
[/TR]
[TR]
[TD]February
[/TD]
[TD]Cook
[/TD]
[TD]New
[/TD]
[TD="align: right"]95
[/TD]
[/TR]
[TR]
[TD]February
[/TD]
[TD]Cook
[/TD]
[TD]New
[/TD]
[TD="align: right"]780
[/TD]
[/TR]
[TR]
[TD]March
[/TD]
[TD]Brooks
[/TD]
[TD]New
[/TD]
[TD="align: right"]900
[/TD]
[/TR]
[TR]
[TD]March
[/TD]
[TD]Albert
[/TD]
[TD]Existing
[/TD]
[TD="align: right"]875
[/TD]
[/TR]
[TR]
[TD]March
[/TD]
[TD]Brooks
[/TD]
[TD]New
[/TD]
[TD="align: right"]50
[/TD]
[/TR]
[TR]
[TD]March
[/TD]
[TD]Brooks
[/TD]
[TD]New
[/TD]
[TD="align: right"]875
[/TD]
[/TR]
[TR]
[TD]March
[/TD]
[TD]Cook
[/TD]
[TD]Existing
[/TD]
[TD="align: right"]225
[/TD]
[/TR]
[TR]
[TD]March
[/TD]
[TD]Cook
[/TD]
[TD]New
[/TD]
[TD="align: right"]175
[/TD]
[/TR]
[TR]
[TD]March
[/TD]
[TD]Brooks
[/TD]
[TD]Existing
[/TD]
[TD="align: right"]400
[/TD]
[/TR]
[TR]
[TD]March
[/TD]
[TD]Albert
[/TD]
[TD]New
[/TD]
[TD="align: right"]840
[/TD]
[/TR]
[TR]
[TD]March
[/TD]
[TD]Cook
[/TD]
[TD]New
[/TD]
[TD="align: right"]132
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Oeldere]

use a helpcolumn to determine the value.

After that you can make a pivot table to analyze the data, you asked.

 

[chetanmehra1989]

use this one

=+COUNTIFS(A:A,"January",B:B,"Brooks",D:D,">1000")