Trouble with SUMIF formula on totals tab

Hello All!

Please help!

Again, I am not sure if this is possible, but I would like to build a totals tab that will pull from all other tabs in the workbook. My issue is that I am using drop down lists and manually inputting the frequency of some cells and cannot figure out how to count the correct event from the drop down list and have the formula pull from all rows where the event occurs. I need a formula that will recognize a name/event whenever it is typed and multiply it by the frequency in order to get the total frequency, amount paid, hours, etc.


Does this make sense??

I have attached the workbook as an example.

-Hannah

What I would like is to be able to sum the total the frequencies, hours billed and payment amounts for each client. I am having difficulty because the clients do not appear in the same rows for every tab.