=SUMIF(C3:C445,value_to_test_against,L3LL445)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dantheman" wrote
in message ...

I would like to be able to write a formula that would check a column
(column C row 3 thu row 445))for sets of numbers that match. If there
is a match, then go to column L of that corresponding row and add that
number found in column L and post the sum of all numbers found in
column L to cell A447. Is this possible? Can anyone Help! Thanks:)


--
Dantheman
------------------------------------------------------------------------
Dantheman's Profile:
http://www.excelforum.com/member.php...o&userid=35117
View this thread: http://www.excelforum.com/showthread...hreadid=548722