I've been trying to get my head around this for to long and it's time to ask for help. I am new here, but with a new found excitement for Excel because of this project. I've embarked on this project to help my wife keep track of her customers, sales, expenses and other work related items. I've been able to google and figure out the formulas and get the data to answer questions we have but recently she asked if I could have it tell her how much per hour she is making based on the date. So I created her a column that houses the Hours worked.
In the Sales sheet I'm trying to SUMIFS the date column (B), the amount (E), and divide that number by the Hours (A). I've come up with =SUMIFS(E7:E10000, B7:B10000,"/"&L3,A7:A10000,L5) that doesn't work. Anyone have any ideas on how to make this happen? Maybe SUMIFS isn't the correct formula to do what I'm trying to do? I've attached the workbook. Any help is greatly appreciated.
Bookmarks