Sum based on condition / cell value change....

[z07924]

Say, sheet1 has 5 columns and 10 rows. I want to calculate sum of each column based on some other field. for e.g.,

Worksheets("sheet2&quot.Range("E34&quot = "AB" or Worksheets("sheet2&quot.Range("E34&quot = "CD"
{
....
do the sum
....
}

My question is this...

WHENEVER a cell value changes the corresponding sum should be recalculated once you leave the cell...how do I do that?
I have 5 different columns and each column has 10 rows...

can someone please help....thanks.

 

[z07924]

any help please?

 

[euskadi]

You can do this within the worksheet itself:

pick any cell and enter this (or something like this)... let's say your data is in the range A110 and you are wanting the sum for column D if cell A has "AC" in it.

=sumif(A1:a10,"AC",D110)

Now any time the cells change this equation will update as long as you calulate or leave calculation on.

 

[z07924]

Thanks for responding. Sorry I may not have stated the problem clearly. Let me try it again...

Say, I have data in A1:A10. I want to sum this data and multiply the sum by a number based on three conditions from another sheet..

If Worksheets("external&quot.Range("E34&quot = "AB" OR Worksheets("external&quot.Range("E34&quot = "CD" OR Worksheets("external&quot.Range("E34&quot = "EF"

Worksheets("original&quot.Range("A11&quot.value = 0.625 * sum(A1:A10)

How do I do this? I want to attach this macro/vba to cell change event so that whenever data in A1:A10 changes, A11 will be recalculated...

thanks for any help...