Excel Pivot to summarize by category all rows based at least one row containing criteria

I'm trying to figure out out to make a pivot table to sum all rows by category when one at least one of the rows contains a specific value. In the attached example, I want to sum the cost for all rows by category but only if there is at least one row containing type car. Both the New and Sold Categories have 1 or more rows with a car so I want those summed. The used category does not contain any cars so I don't want those included. The pivot table should result with New = $51,000 and Sold = $50,000 for a grand total of $101,000.

I think the only way to solve this is to have a help column.
I named it Category has Car. That uses the formula, that will have TRUE or FALSE as result

Please Login or Register  to view this content.

Then you can create a pivot table with the helper column as filter set to TRUE
and Catecory in the row area and cost in the values area
(see attached file)


__________________
since you use Microsoft 365 I also added a bonus answer using the new dynamic array functions and parameters.

I used the Unique() and Filter funtions to spill all categories with a Car

Formula:

Please Login or Register  to view this content.

and I used a SUMIFS. this function will spill based on found results because I added the # after the cellreference to ($H19#)

Formula:

Please Login or Register  to view this content.

If you add a line that has category Used and type car you will see that the category and sumamount is added below Sold instantly.