Congratulations @theexcelclub! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

<table><tr><td><img src="https://steemitimages.com/60x70/http://steemitboard.com/@theexcelclub/votes.png?202001022336"></td><td>You distributed more than 20000 upvotes. Your next target is to reach 21000 upvotes.</td></tr>
</table>

<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@theexcelclub) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=theexcelclub)_</sub>
<sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>


To support your work, I also upvoted your post!


###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!

There is conditional format for Total (i.e, Bold and Lines). How it is done?.<br/> - Kishore Kumar<br/>
 > This comment was made by a guest account using @steempress. Rewards will be sent to the user once they have a Steem account

Hello,

Your post has been manually curated by a @stem.curate curator, @balticadger.

<center>![FA8866FD-F2C3-43B3-A5A5-E0324BA4BB47.jpeg](https://cdn.steemitimages.com/DQmaqMpaEpJBAwJMN9bCHhmTzUEuymBj8V4BMsiJteZMG7L/FA8866FD-F2C3-43B3-A5A5-E0324BA4BB47.jpeg)</Center><center> *Supporting Steemians on STEMGeeks*</center>

We are dedicated to supporting great content, like yours on the [STEMGeeks](stemgeeks.net) tribe.

If you like what we are doing, please show your support as well by following our [Steem Auto curation trail](https://steemauto.com/dash.php?trail=Stem.curate&i=1).

Please join us on [discord](https://discord.gg/73WaANa).

@paulag Paula, is the video above on how to create Dynamic Positioning of Totals using Dynamic arrays using Excels SEQUENCE function, has anything to do with the above Learn and Earn Activity? Are the both using the same method? I'm sorry I kind of confuse right now.

This is what I did using Microsoft Excel online.

For pull in the Amount of the invoice into column H:
In cell H5, as I typed in =SUM, a drop-down list appeared, and I double-click on SUMIFS and =SUMIFS( filled in the cell H5. Then, I clicked and dragged from cell C1 to cell C11. Then, I typed ',' and then I clicked and dragged from cell A1 to cell A11. Then, I typed ',' and then I clicked on cell A2, and then I typed ')' and press Enter. Number 319 filled in the cell H5.
In cell H6, as I typed in =SUM, a drop-down list appeared, and I double-click on SUMIFS and =SUMIFS( filled in the cell H6. Then, I clicked and dragged from cell C1 to cell C11. Then, I typed ',' and then I clicked and dragged from cell A1 to cell A11. Then, I typed ',' and then I clicked on cell A3, and then I typed ')' and press Enter. Number 473 filled in the cell H6.
In cell H7, as I typed in =SUM, a drop-down list appeared, and I double-click on SUMIFS and =SUMIFS( filled in the cell H7. Then, I clicked and dragged from cell C1 to cell C11. Then, I typed ',' and then I clicked and dragged from cell A1 to cell A11. Then, I typed ',' and then I clicked on cell A4, and then I typed ')' and press Enter. Number 267 filled in the cell H7.

For total value of all invoices:
In cell H8, as I typed in =SUM, a drop-down list appeared, and I double-click on SUM and =SUM( filled in the cell H8. Then, I clicked and dragged from cell H5 to cell H7. Then, I typed ')' and press Enter. Number 1059 filled in the cell H8.

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.