Subtotal accounts payable by week due

[Gregory65]

Column B contains invoice dollar amounts. Column E contains code 1, 2, 3, 4, or 5 to indicate payment due in current week (1), next week (2), the week after that (3), etc. Need invoice subtotals for each of the 5 weeks. Thanks!

[#2]

Hello,

See the link below on how to create subtotal

https://edu.gcfglobal.org/en/excel2016/groups-and-subtotals/1/

[#3]

@Gregory65 

As variant you may use SUMIF function or Pivot Table to show accounts payable due for each week.