| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorted appearing table (vlookup, if, concontinate)???
some good information he
http://xldynamic.com/source/xld.SUMPRODUCT.html "Luna" wrote: I am using excel 2003. I now have the data devided. though other then for perchase column c always =1. I am thinking it needs to be a combo of SumIF and Vlookup. as i am unfermiallar with SumProduct. i suppose i am hoping there is a tutorial out there in the world that shows how that would be used. "JMB" wrote: Let's say level is in A1:A8, item description is in B1:B8, and amount is in C1:C8. Also, assuming that for purchased items, the level number in column A is either empty or 0. The level attained is in F1, item description you want totaled is in G1, try this formula in H1: =SUMPRODUCT(--($A$1:$A$8<=F1),--($B$1:$B$8=G1),$C$1:$C$8) Adjust ranges to suit, but prior to XL2007, sumproduct cannot use an entire column (eg A:A). It's not clear from your data if the item description and amount are in separate columns (looks like they may be concatenated together in the same cell). I would split these - I think it would make it easier to work w/the data. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why can't this table be sorted? | Excel Discussion (Misc queries) | |||
| VLOOKUP always required the searching field SORTED? | Excel Programming | |||
| Why must the table for Vlookup be sorted in ascending order? | New Users to Excel | |||
| Using VLOOKUP without a sorted list | Excel Programming | |||
| vlookup for a value appearing more than once | Excel Worksheet Functions | |||
Threaded Mode
