LinkBack URL
About LinkBacks
Hello, I need help
This excel 2007. So its basically an invoice log that we want to see what each store is accumulating in expenses. All store tabs are set up as tables. We need it to all capture it by supplier.
Hello, I need help
This excel 2007. So its basically an invoice log that we want to see what each store is accumulating in expenses. All store tabs are set up as tables. We need it to all capture it by supplier.
To capture the suppliers, in A7 copied down:
=IFERROR(INDEX(Store2[Company],MATCH(0,INDEX(COUNTIF(A$4:$A6,Store2[Company]&""),),0)),"")
NB Supplier consolidations A4 MUST be left blank.
annual total in B7:
=SUMIF(Store2[Company],A7,Store2[Amount])
monthly totals in C7, copied across and down:
=SUMIFS(Store2[[Amount]:[Amount]],Store2[[Company]:[Company]],$A7,Store2[[Approval Date]:[Approval Date]],">="&DATE($A$2,MONTH(1&C$4),1),Store2[[Approval Date]:[Approval Date]],"<"&DATE($A$2,MONTH(1&C$4)+1,1))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
awesome Thank you so much!
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
Please update your profile to reflect that. It tells use what features/functions you have available and speeds solution.Originally Posted by Flora Lastra
If you forget how to do this:
Above your first post click Forum Actions then Edit Profile.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks