Excel Formula Help

[gjrc]

hi guys,

i dont know if anyone can help me, but i have a spreadsheet that keeps changing.

i will try to explain.

say column a has values in it. next to column a i mark agaisnt some that they are more important and need to be totaled seperatly.

is there a way i can make excel detect which i mark in column and then get the value from column a and use it in another formula.

does that make sense.

thanks in advance if you can help

g

 

[uv]

mark in column B, then Data>AutoFilter>choose the marking.

column A will only show ones where column B has a mark, then in column C you can use the formula with column A data in it

I'll explain more if you think I explained utter garbage!

 

[gjrc]

ok, but i need to show all the data from column a all the time.

the data in column a alwasy stays the same, its just sometimes it needs to be used in one calculation and removed from another.

i was wondering if there was a way buy using column b an dlabelling next to the data that excel can recognise which formula to put the data into, without me editing each formula and removing or adding the cell in column a.

 

[MTA99]

Not sure i've understood correctly but in column C could you not use an "IF" command to say IF column B is 1 (ie.important) then use this formula and data from column A to calc result, else use the other formula.

 

[gjrc]

Not sure i've understood correctly but in column C could you not use an "IF" command to say IF column B is 1 (ie.important) then use this formula and data from column A to calc result, else use the other formula.

that sounds about right yeah, so how would a formula work that say

if call b1 = A then get cell a1 and apply to formula c1 (formula c1 = (sum any cells here)

 

[A[L]C]

This will look at column B. If there is an 'a' in the cell, it will add the value of the cell to the left.


=SUMIF(B1:B10,"=a",A1:A10)

 

[gjrc]

This will look at column B. If there is an 'a' in the cell, it will add the value of the cell to the left.


=SUMIF(B1:B10,"=a",A1:A10)

that is genius. thanks mate!!

 

[A[L]C]

that is genius. thanks mate!!

np give me a shout if u need any more help