SOLVED

New Contributor

# Summing Help

Hello! I need a wizard..

I'm looking for a specific formula, IF O82 = "x" then cell S82 is added to cell G76

Is this possible?

6 Replies

# Re: Summing Help

yes. And where do you want that sum to go? If you want G76 to reflect that sum and G76 is something like =SUM(G1:G74) then in G76 use the following: =SUM(G1:G74) + IF(O82="x",S82,0) or slightly smaller version =SUM(G1:G74) + (O82="x")*S82
best response confirmed by heavyequipcole (New Contributor)
Solution

# Re: Summing Help

It looks like G76 now contains a formula similar to

=SUM(G10:G74)

(The exact range may be different)

Change it to

=SUM(G10:G74)+SUMIF(O82:O84,"x",S82:S84)

# Re: Summing Help

@Hans Vogelaar That was EXACTLY what I was looking for. I'm going to make it harder for you now...

following suite.... IF O82:O84 have "x" am I able to get Cell U82 and T82 to autopopulate to another tab??

# Re: Summing Help

Which cell(s) should be populated on which sheet?

# Re: Summing Help

@Hans Vogelaar U82:U84 to reference on the Sales Agreement Sheet in Cells K11:K13 IF O82 has a value of "x"

# Re: Summing Help

In K11:

=IF('Other Sheet'!O82="x",'Other Sheet'!U82,"")

Replace Other Sheet with the name of the sheet in your screenshots.

Fill down to K13.