Sheets Formula Help

[jtilleyx]

I usually manage okay with Excel, but I struggle with Sheets for some formulas. Hoping someone could help with 3 formulas that I expect to not be too difficult. but I've been stuck with this for a while now.

2 tabs
1st one is the "working tab" the 2nd is the 'data" tab

On the 1st tab would be entered a start date, end date, and a numeric value

Based on the information above, reference the data tab and return 3 values

in A - How many unique users in this date range (ignores numeric value entered)
In B - How many unique users in this date range had unique appliedcat equaling value in H1.
In C - What is the sum of the totalrate for all unique users in this date range that worked in the specified number of unique categories?

I don't see a way to upload file, so hopefully screen shots can help

Tab 1

Tab 2

Thank you for any help offered

 

[jtilleyx]

I usually manage okay with Excel, but I struggle with Sheets for some formulas. Hoping someone could help with 3 formulas that I expect to not be too difficult. but I've been stuck with this for a while now.

2 tabs
1st one is the "working tab" the 2nd is the 'data" tab

On the 1st tab would be entered a start date, end date, and a numeric value

Based on the information above, reference the data tab and return 3 values

in A - How many unique users in this date range (ignores numeric value entered)
In B - How many unique users in this date range had unique appliedcat equaling value in H1.
In C - What is the sum of the totalrate for all unique users in this date range that worked in the specified number of unique categories?

I don't see a way to upload file, so hopefully screen shots can help

Tab 1
View attachment 89784

Tab 2
View attachment 89785


Thank you for any help offered

Updated:

For the 1st part, I am able to use a helper column with:
=FILTER(Data!$A$2:$A,Data!$O$2:$O >= $D$2,Data!$Q$2:$Q <= $E$2)

and then a 2nd helper column with:
=UNIQUE($A$2:$A,FALSE,FALSE)

This gets me to the total number of unique users for a specified date range. Step 1 okay


Next, I need to determine how many unique categories each of these users worked in.
In words, something like: lookup each user on the list returned from part one: countunique catagories that fall within the timeframe from part one.