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.