Ian Jones
Ian Jones

Reputation: 7

MS EXCEL 365: I need to create a running balance from a 2d array

This function produces a 2d array:

=COUNTIFS(Sheet22!C:C,B5#,Sheet22!A:A,Sheet21!E4:Sheet21!I4)

I 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

Answers (0)

Related Questions