Home

Subtotal accounts payable by week due

%3CLINGO-SUB%20id%3D%22lingo-sub-1116948%22%20slang%3D%22en-US%22%3ESubtotal%20accounts%20payable%20by%20week%20due%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1116948%22%20slang%3D%22en-US%22%3E%3CP%3EColumn%20B%20contains%20invoice%20dollar%20amounts.%20Column%20E%20contains%20code%201%2C%202%2C%203%2C%204%2C%20or%205%20to%20indicate%20payment%20due%20in%20current%20week%20(1)%2C%20next%20week%20(2)%2C%20the%20week%20after%20that%20(3)%2C%20etc.%20Need%20invoice%20subtotals%20for%20each%20of%20the%205%20weeks.%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1116948%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1116958%22%20slang%3D%22en-US%22%3ERe%3A%20Subtotal%20accounts%20payable%20by%20week%20due%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1116958%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3ESee%20the%20link%20below%20on%20how%20to%20create%20subtotal%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fedu.gcfglobal.org%2Fen%2Fexcel2016%2Fgroups-and-subtotals%2F1%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fedu.gcfglobal.org%2Fen%2Fexcel2016%2Fgroups-and-subtotals%2F1%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1117240%22%20slang%3D%22en-US%22%3ERe%3A%20Subtotal%20accounts%20payable%20by%20week%20due%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1117240%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F524305%22%20target%3D%22_blank%22%3E%40Gregory65%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%20you%20may%20use%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fsumif-function-169b8c99-c05c-4483-a712-1697a653039b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESUMIF%20function%3C%2FA%3E%26nbsp%3Bor%20Pivot%20Table%20to%20show%20accounts%20payable%20due%20for%20each%20week.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Gregory65
Visitor

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 Replies
Highlighted
Hello,

See the link below on how to create subtotal

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

@Gregory65 

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

Related Conversations
Accounts limit in Edge for iOS and iPadOS
Ole Thomsen in Discussions on
3 Replies
Customize user profile in Teams
arielmw2 in Microsoft Teams on
2 Replies
AD groups in update management (azure automation accounts)
PatrickF11 in Azure on
1 Replies
Move tasks to another account
bpatterson in Microsoft To Do on
0 Replies