What I am trying to accomplish is having one collection of summary data at the top of the more detailed information. I would like the summary data to change depending on the filter applied. I can get the data to change with the applied filter with the SUBTOTAL function and can get the data to be summarized counting the way I want. ( I need to count the different numbers that occur without counting duplicates) The problem I am facing is with embedding the SUM/IF/FREQ function bulleted below within a Subtotal function.

• =(SUM(IF(FREQUENCY(F40:F60,F40:F60)>0,1)))
o counts the different numbers that occur without duplicates
• =SUBTOTAL(3,F24:F60)
o I am using to count only what is filtered

I relize I can not embed the count function I need instead of the prexisting 1-9 options given for SUBTOTAL but is there another alternative to achieving the same effect?

Here is an example of my data: example of CR.png