as im sure there have been numerous threads before on this topic, i ask your forgiveness in advance.
have an excel question for a google doc im setting up.
i have a risk column 'A', to win column 'B', and a result column 'c'
i also have a total won "g" box, a total loss "h" box, and a yield "i" box
my question is what formula do i need to have boxes 'g' 'h' 'i' auto update after i record what happens in the result column 'c'?
ex...
risk 'a' to win 'b' result 'c' total won 'g' total loss 'h' yield 'i' 33 30 L ?? ?? ?? 110 100 W
i want it to automatically update after i type either 'L' or 'W' in the result column. is this SUMIF, DSUM?? Any help is greatly appreciated.