Formula stopped working...

  • Thread starter Thread starter atom
  • Start date Start date
A

atom

=SUM((D131={5,10,20,30,50,100})*{10,20,35,60,100,210})

This formula worked fine from row 7 to row 131. Then starting on row
132, it stopped working. The formula is in cells 132 - 300, but it
doesn't work anymore. Same formula, but no result.

What gives??
 
atom

"doesn't work" is not too descriptive. What results do you get?

Which column is it entered in?

I'm assuming you copied it down from row 7.

Perhaps you have no data in column D past row 131?

Gord Dibben XL2002
 
"doesn't work", meaning I get no result. The formula is in F7, and it
was copied down to F300. I manually enter data in the cells column D and
get a result in F. Everything's the same but it just doesn't work past
row 131
 
When I placed your formula in column F1:f300, it looked up the value in
col D(same row). If the value in D was the same as a value in the first
array (5,10,20...100) it returned the matching value in your 2nd array
(10....210) to col F. Otherwise F was zero.

QUESTION: Do you have any values in d132: d300? If so, are they
NUMERIC?
 
OH! I just figured it out: somehow, the cell format in D got changed to
text. Your question about Numeric values tipped me off to the problem.

Thanks!
 
Back
Top