Conditional Sumif Formating Formula

[robocop1906]

Trying to get the following conditional formating formula to work. I'm trying to highlight values that don't equal 40 in column Q based on duplicate values in D.

Thoughts? Thanks in advance.

=(SUMIF(D:D,D:D,Q:Q))<>40

 

[texasalynn]

are you looking for the individual cell to have a value <> 40?

 

[robocop1906]

Combined total

Entry 1 = 20
Entry 1 = 25

So both numeric cells would highlight since the combined total for for 'Entry 1' does not =40

 

[texasalynn]

that is not going to be possible with just a formula in conditional format. You would need a helper column. Will the totals only be for the current and next line? Or would it be a running total (line 1 + line2, then line 1+2+3,etc)?

 

[robocop1906]

Running total

 

[texasalynn]

does this work for the formula
=(SUMIF($D$1:D1,D1:$D$1,$Q$1:Q1))<>40