first, hi im new to the forum and i have no idea if this is going to be in the right place or not but im wingin it.
i got a list of "items" with a "value" beside it (i use [ ] to represent cells)
[item1] [2]
[item2] [6]
[item3] [9]
at the top i keep a list of the items and numbers and a few rows down i want to start a list keeping track of those items and values.
example:
[item1] [2]
[item2] [6]
[item3] [9]
[ ] [ ]
[ ] [ ]
[item3] [24]
[item1] [6]
[item2] [2] (so on)
i want the numbers at the top to calculate a total of each item and its value.
example:
i want item1 to search the worksheet and find everything with the text "item1" and add the value beside it.
[item1] [2] <<searches for text "item1" then ads the number beside it "6", "2+6=8"
[item2] [1]
[item3] [6]
[ ] [ ]
[ ] [ ]
[item 1] [6]
i hope this is not to confusing....if it is im sorry and ill make up a sheet to explain what i mean
thanks hope to hear something soon.
Bookmarks