Report number of instances in another sheet based on variable conditions

Hi all,
First time post from me, as is so often the case with Excel I know what I want the workbook to do, I just dont know how to ask it to do that.

Screenshot 2024-12-09 092026.png

This is my front sheet "Main!", each "User" has their own sheet as you can see.
Cells C2 and D2 are manually inputted dates, which currently dictate the search parameters for the "spend" in column B.
Cell F2 is a dropdown list of all the names given in column A.
Cell G2 is a dropdown list of tool types, this list is also used in each of the "User" sheets.

Here is an example of a "User" sheet.
Screenshot 2024-12-09 100140.png

Most of this data is manually inputted, the only exceptions are the previously mentioned list of tool types that you see in B,F,J,N,R,V,Z 3:20 and the "Total" in Row 21 which is a sum of the induvidual "Price" Columns.

What i would like the formula to do, is Report in Main!H2 how many instances of the tool type selected in Main!G2 appear in the sheet for the user shown in Main!F2 between the dates specified in Main!C2 and D2.
Hopefully that makes some small amount of sense!
If any clever sorts out there are able and willing to advise me further, it would be very much appriciated.
Havent played with Excel in anger for many years, I'm picking it up again, slowly but surely.

Thanks!
Tony.

Your sheet name is inconsistent. e.g. "user 1" and "user1" is different.

I use substitute to handle this situation.

H2

Please Login or Register  to view this content.

Thanks for the reply, I am aware that the List name reads "User 1" and the sheet name is "User1" this is by design, when setting up the hyperlink, i set the destination as "User1!" and set the Cell to display "User 1" I just felt this made things easier to work in my live sheet where "User 1" is replaced with a name.