RE: RE: Dynamic Positioning of Totals using Dynamic Arrays
You are viewing a single comment's thread from:

RE: Dynamic Positioning of Totals using Dynamic Arrays

tansm11(44)
Published in
Excel For All
Words
63
Reading
1 min
Listen
Play
7y

For pull in the Amount of the invoice into column H:
In cell H5, I typed in =SUMIFS(C1:C11,A1:A11,A2).
In cell H6, I typed in =SUMIFS(C1:C11,A1:A11,A3).
In cell H7, I typed in =SUMIFS(C1:C11,A1:A11,A4).

For total value of all invoices:
In cell H8, I typed in =SUM(H5:H7). That gives a total of 1059.

Paula, am I doing it right? I hope that I'm doing it right.

via steempress
This post was published via steempress. Ecency is not the originator or editor of this content and displays it for discovery purposes only.
2