use formular to caculate summarize with condition

[thaimic]

Hi all,

I have one excel file as attached.
please help to issue formular to caculate summarize with condition.
thank in advance.

[Fotis1991]

Hi

In C3 and copy down use this.

Please Login or Register  to view this content.

For your other issue, can you explain a little more pls?

[thaimic]

thank for the reply,

But I have many condition at the column A, for examle 700, 800, 900
But when I input 800 then ....

can you give formular again. or see book2 again.

thank in advance

[Fotis1991]

Perhaps.

Please Login or Register  to view this content.

[thaimic]

with your fomular there is only diplayed a value. please help to check again.

[Fotis1991]

You get these kind of problems because you use merged cell. This is a very bad choice..

Good luck.