Difficulties With Formula

[meppwc]

Can someone please assist with this?
If the value in column A="301", then sum column G, divided by, sum column K

 

[dreid1011]

What exactly are the difficulties you are having?

I would use something like this:

=IF(A2=301,SUM(G2:G100)/SUM(K2:K100),"")

 

[Aladin Akyurek]

Does 301 occur just once in A or multiple times? If the latter try to post a tiny sample from A, followed by a corresponding sample from G, and followed by a corresponding sample from K, along with the expected result for 301 fot these three column sample.

 

[meppwc]

Thank you all...........based on this discussion I was able to figure out the formula that I needed using SUMIF............I used several cells but it worked.. .....P2 points at the "301" value

Q2: =SUMIF(A:A,P2,G:G) -- (419287)
R2: =SUMIF(A:A,P2,K:K) -- (5040000)
S2: =Q2/R2 -- (8%)

 

[dreid1011]

Glad you got it sorted out.