sum up feed, and get information on where it came from

[abrunstad]

Hello agin! =)

Now, I really have a challenge..

In a sheet for calculating total feed given to fish,
I'm trying to accomplish a sheet that will calculate the total feed given, in witch cages they occur, and what brand they are.

the order of the feed and in what cages they are given will differ with the date.

Please see the attached sheet for a better understanding.

Regards, Andreas.,

[DonkeyOte]

I suspect this may not be viable for you but to avoid need for array / UDF you could perhaps use something like: