Reputation: 7
This function produces a 2d array:
=COUNTIFS(Sheet22!C:C,B5#,Sheet22!A:A,Sheet21!E4:Sheet21!I4)
B5#
is list of unique values on sheet22
e4:i4
are datesc5:c22
is the starting balance/count for each row or unique itemI am failing miserably in transforming the count that the formula produces to a running balance, that is in feeding the output of the formula into a formula to give a balance each time rather than the count:
example row: b5 = trees, c5 = 10 (starting balance for trees), e5 (where the formula above is) correctly counts 3 against date in e4,
but I want the following:- b5= trees, c5 = 10, e5 = 7 (10-3=7) then f5 (count of trees for date in f4 = 1) = 6 (10-3-1=6), etc. for each date and for each item for each row.
Thanks in advance and for looking
Upvotes: -3
Views: 23