Pivot with Countifs

[GordonLS]

Good morning. I have a pivot table that I am using to pull in costs. I have 3 columns A, B, C.
For each Category I need to charge $2.00 for each unique code with a unique Date.
For each Category if the code is not unique and the date is not unique than I also need to charge $10.00 for that group.
For each Category if the code is not unique and the date is unique I need to charge $2.00

The example column shows how these would be charged.
The count column is what I would need to say if cell =1 than will be $2.00 and if greater than 1 the charge will be $10.00

I need to populate column F with the category ,column G and J with the number of occurrences and column H and K with the charge.

 

[awoohaw]

would you be kind enough to help the forum help you and post a mini worksheet using the xl2bb add in. the link is below.
I cannot read the data in the image to build a test using your data.

 

[awoohaw]

Here is an attempt:

Book1
	A	B	C	D
1
2	Bill	IS8727_M	2022-08-02	2
3	Jane	IS8728_L	2022-08-02	2
4	Tom	IS8727_M	2022-08-04	10
5	Harry	IS8727_M	2022-08-04	10
6	Sally	IS8728_M	2022-08-05	2
7
Sheet1

Cell Formulas
Range	Formula
D2:D6	D2	=IF(COUNTIFS($B$2:$B$6,B2,$C$2:$C$6,C2)=1,2,IF(COUNTIFS($B$2:$B$6,B2,$C$2:$C$6,C2)>1,10,2))

 

[GordonLS]

I will give it a try.

Thank you.