What if Formulas

  • Thread starter Thread starter Dantheman
  • Start date Start date
D

Dantheman

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:)
 
=SUMIF(C3:C445,value_to_test_against,L3LL445)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Thanks, I think we're on the right track. But my sum cell shows "0"
which can't be true. Any other ideas? Thanks.:)
 
Dan,

can you show the data and your exact formula. Just type it into the message
with appropriate spacing for readability.

--
HTH

Bob Phillips

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