I have a spreadsheet that I would like to create somewhat of a dashboard for, that will count totals for me, based on a few criteria. I am trying to use the SUMIF function, but I can't capture down to level I would like to.
I have attached a file, so you can see what I am about to explain.
I have 1 worksheet, that has 4 Components (which are basically 4 different customers). Each have been given quantities of trucks, that where purchased with 3 different types of funding. Once I have shipped and actually signed the trucks off to a component, I update the quantity hand-off column of my worksheet. Then I also record the date of the hand off transaction. The other tab is the worksheet I would like to capture my summary data. ozgrid.com/forum/core/index.php?attachment/69842/
I would like to count, how many trucks were handed off to a component, under each line of funding, by fiscal year (10/01/xx-09/30/xx)
Can anyone help me?
THANK YOU IN ADVANCE!