You are viewing a single comment's thread from:
RE: Dynamic Positioning of Totals using Dynamic Arrays
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.
without dynamic arrays, you would enter a formula to each cell. Have you tried it with dynamic arrays? ( what version of Excel are you using?)
I have went through the video above and I couldn't get the understanding on how to apply the dynamic arrays onto the Learn and Earn Activity above without entering a formula to each cell.
I'm using my laptop that installed with "Linux Mint 19.1 Cinnamon" OS.
I'm using FreeOffice PlanMaker 2018 (rev 973.1103) 64bit.
It is an alternate version of Excel for my Linux OS laptop.
ah, so you don't have the dynamic arrays feature in the package you are using. you could try excel online :-)
Okay, I will use Excel online.