PRODUCTSUM for different quantities

A problem I am having is summing hours based on a given oil filter. I want to sum the hours on the first filter for Bus 2 in K4 and same for Bus 1 in the row above. The criteria is oil change: yes or no? If yes, it counts that current time for the next oil filter similar to the example in the attached. If no, the hours will cumulate under one filter in K4 until "yes", K5 will start a new cumulative sum. Data will constantly be updated and added so the oil filters will also grow and expand.

I am guessing that I might have to do some conditional manipulation of the data in order for this to work; similar to how a dynamic graph works with its data constantly being updated except with sums and tables; I'm not too worried about graphs here but data grouping and manipulation.

Bumping this thread. Still need help.

looking at your examples, i see that you are adding a "yes" value with a "no" value. shouldnt that be the other way round? as in...the filter was changed, so now we start recording how long before the next change?

it almost looks like you are starting to track the filter life from the start of the time that it got changed at the end of that shift (if that makes any sense lol) ie, we change it tonoght, but you start adding from this morning?

ok so which numbers are we using then? should i move them down to line up, or can you provide an updated file?

FDibbins,

Cell K2 would show the first filter or the hours ran for Car 1 from "Yes" to the last "No". The second filter for Car 1 would be shown in L2.

Car 2 filters and hours would be listed below in K4.

This might make the equation more complicated but instead of having "Yes" the brand of the filter is labeled there to show not only the hours placed on the filter but what brand it is too. This would have the same funcationality as "Yes" to the last "No" except now it is Brand to last "No".

i added a helper column K (hide if you want). Check the values under the values you had under your filter numbers, see if they are what you want?

to get the Brand totals, you will have to fill them all in 1st, then you can modify the ranges in my formula for them too

hope this helps?

the way the formula was written was prercisely to change the filter number when the "yes" changed.

I can understand how the "brand" will change (or not) from 1 change to the next, but are you saying that you take a filter off 1 car and put it on another car part way thtough the test??

ok, so a filter that is put on a car will stay on that car until the test is done. i understand that each car's filter change is indepenent from the other

hmm mm can you sho me how you arrive at the values you have for filters 2, 3 and 4 plz?

maybe what you are trying to achieve would be easier to do if you seperated the car 1 and car 2 data (time and machine time). that would make isolating the info for each car much simpler, beacuse i am unable to see where car 1 time stops and car 2 time starts...the filter times at between the "yes's" seem to all apply to car 1, yet you have a car 2 in the middle of the 2 "yes's"

as requested in my previous post, please tell me what values you expect to have, and how you arrive at them?