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

Escanaba
Escanaba used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial