Using SUMIF to divide 2 cells

[Dirkelton]

Can anyone help. I'm trying I'm trying to divide 2 columns by each other if another column equals X

For example if column A equals 10, then divide the total of Column B agaisnt the total of column C.

I've tried extending the SUMIF formula in a number of ways (example below) but had no joy.

=sumif(A2:A10,="10",(sum(B2:B10))/(sum(c2:c10)))

 

[barry houdini]

Do you mean

=SUMIF(A2:A10,10,B2:B10)/SUMIF(A2:A10,10,C2:C10)

 

[Dirkelton]

So simple, I tried numerous other combos but that. Reckon I need to go home.

Thanks Barry

 

[Scarface]

Although your question is given, this helped me on the same topic

http://www.mrexcel.com/forum/showthread.php?t=536074

 

[energman58]

=SUMPRODUCT(--(U4:U8=10),(V4:V8))*SUMPRODUCT(--(U4:U8=10),(W4:W8))

Sums the total values in column V and in column W for those rows where column U = 10 and then multiplies them together. Is this what you were trying to do?

Alternatively

=SUMPRODUCT(--(U4:U8=10),(V4:V8)^-1,(W4:W8))

Divides each value in W by the corresponding value in V and adds those up where U = 10

Couldnt understand what you are driving at but I guess it must be one of these two