We help IT Professionals succeed at work.

Excel Loop Formula (Change cells based on result of another cell)

Hello,

Seeking assistance on a formula that sums column D per ID (column B).  If the result is more than 0 it should read 'True' in the result column (E).  Here is the catch....I also need column D to show as 'True' for all other matching IDs.  So in the attached example, you see there is a 1 in cell D5.  Since the sum for ID 65656 is greater than 0, all rows that have ID 65656 have a 'True' in column E.

Thanks!
EE-Example.xlsx
Comment
Watch Question

Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
Hi,

Try below formula in E2 and drag down:
=IF(SUMIF($B$2:$B$6,$B2,$D$2:$D$6)>0,"TRUE","")

Open in new window

Escanaba_Condition_Sum_v1.xlsx
John MarshallVisio developer

Commented:
Can you elaborate?
EscanabaManager - HR Analytics

Author

Commented:
Works great (as always).....Thanks!