As a novice, one of the first things I might recommend for something like this is to get your data into a good "database" -- rather than 3 different sheets for 3 different soaps, put all of the data into a single sheet in a good database format. One record for each "trial"/"sample" and all of the needed "fields" for each trial -- id#, soap type, faucet time, quantity of soap, anything else.

With a good database, the frequency data should be easily computed using the COUNTIFS() function https://support.office.com/en-us/art...c-aa8c2a866842 (another good thing to learn as a novice is how to search and understand Excel's help files). Of course, the COUNTIFS() function does not require that all of the data be in a single database -- it can also work just find for the 3 sub-databases that you currently have. It depends in part on how you want to work with Excel, but there are frequently times when it is preferable to have all of the data in a central database.

In addition to the COUNTIFS() function, Excel has some good pivot table tools that may be useful for summarizing the data. I am not an expert on pivot tables, but you may want to look into learning about them as well. https://www.excel-easy.com/data-****...ot-tables.html

Once you have the frequency data summarized in a table(s) with the COUNTIFS() function, then creating the histogram(s) should be as simple as adding a histogram(s) or column chart(s) (depending on which chart type you prefer to build your histogram):
column charts: https://support.office.com/en-us/art...0-E9AB353C4C00
histogram chart: https://support.office.com/en-us/art...d-80f17ff2f4e8
Note that the built in histogram chart in 2016 may not be able to "filter" the data by soap type and/or # of pumps. It appears to me that you are trying to draw correlations and make inferences about how these three variables are interrelated, and the built in histogram chart may not be able to help. In that case, you will have to use a column chart to build your histogram.

From that overview of the problem, what do you need help with?