matching then adding

[DStayman]

I have a spread sheet that i need to do a Vlookup, or at least I thought. The spread sheet has a bunch of information on a particular piece of property(s). What i need is "P8" to find all cells is column AB that has either A, B, C, D, E, F in it. And if it has those letters I need it to add column t adjacent numbers together. So if property "A" has 3 row's pertaining to it I need it to find those 3 rows, then add all three column T's. Been trying to do a vlookup function and just have been failing terribly. Any help would be most helpful, Thanks!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[Matty]

If I follow correctly, try:

=SUMPRODUCT(--ISNUMBER(MATCH(AB2:AB100,{"A","B","C","D","E","F"},0)),T2:T100)

Matty

 

[DStayman]

That did exactly what i need it to, except i need it to do one more thing if possible, i tried but it said to many functions. I need it to check cell A8 (which will ahve (AB,C,D,E, or F in it) and add up all the A's if its a A, or add up all the Bis if its a b, etc. I tried an IF function but it said to many functions. Thanks for your help on this so far!

 

[Matty]

If I follow, it's simply this:

=SUMIF(AB2:AB100,A8,T2:T100)

Does this do what you want?

Matty