So I am a moron when it comes to Excel. I haven't had to work with it much, but I now have a need to.
I have a set of data, and I need to create a table that I will then import to a power point present.
Attached is a Sheet with a Sample of data. Below the data set is what I would like to my table to look like based on the data above.
What do I need to plug in where to create such a table?
Sample Data.xlsx
use sumifs() make sure everything is spelled the same!
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
A few errors you need to correct...
1. you have Toms Hadrware & Toms Hardware
2. you have a trailing space for Jim in the 2nd table
3. tou have Tool in the top table, but ToolS in teh 2nd table
If you make the headings/names ALL the same, you can use this for the names, copied down abd across...
=SUMIFS($D$2:$D$17,$A$2:$A$17,$A28,$B$2:$B$17,B$27)
and this for the Product, copied down...
=SUMIFS($D$2:$D$17,$A$2:$A$17,$A28,$C$2:$C$17,E$27)
To extract unique vendors, use this in A28, copied down...
=IFERROR(INDEX($A$2:$A$17,MATCH(0,INDEX(COUNTIF($A27:A$27,$A$2:$A$17),0,0),0)),"")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The data was a sample. The actuall data is pulled from an oracle data base and will not have the errors that this sheet. It was something I threw together to illustrate what I am trying accomplish.
That being said, My data will not have a static number of rows each month. How can I make the "Sum If" function dynamic?
use a bigger range?
Extend the range to, say, 1000 - or more. You *could* use entire columns, but I try to avoid that if I can
=SUMIFS($D$2:$D$1000,$A$2:$A$1000,$A28,$B$2:$B$1000,B$27)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks