I want to create a pivot table with countif condition on the count of Coloum B corresponding to Column A.
The data is like
Code FEE AMOUNT
w 10 10
w 12 8
e 11
s 15 6
w 16 8
s 8
s 9 5
e 1 1
e 6 2
w 5 7
n 10
n 4 14
n 7 15


I want to create a pivot table based on the Code Column with but count only those cells with fee>=7, but count the amount column regardless the filter on Fee
the result should be like
Row Labels Count of FEE(>=7) Count of AMOUNT
e 1 2
n 2 2
s 3 2
w 3 4

how the vba code could be?