Countif Query

[Sourav H]

Find from the below table 1. January and February sales

2. January OR Brooks OR Amount > 1000

3. January sales for Brook or Cook Month SalesRep Type Amount January Albert New 85 January Albert New 675 January Brooks New 130 January Cook New 1350 January Cook Existing 685 January Brooks New 1350 January Cook New 475 January Brooks New 1205 February Brooks Existing 450 February Albert New 495 February Cook New 210 February Cook Existing 1050 February Albert New 140 February Brooks New 900 February Brooks New 900 February Cook New 95 February Cook New 780 March Brooks New 900 March Albert Existing 875 March Brooks New 50 March Brooks New 875 March Cook Existing 225 March Cook New 175 March Brooks Existing 400 March Albert New 840 March Cook New 132 <tbody> </tbody>

<tbody>
</tbody>

 

[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")