Home Sum syntax for IF condition in Loop
Reply: 0

Sum syntax for IF condition in Loop

Mike Mann
1#
Mike Mann Published in 2018-02-13 21:37:16Z

Hoping this is an easy answer. Sorry if a dumb question, but I'm trying to figure out the right syntanx for this if statement. I want THEN triggered if the entire row sum is the value of the active cell. How can I correct my code?

Code was working until I added the last OR assessment Or Sum(Rng2.EntireRow) = Rng2.Value

For Each Rng2 In WorkRng2
    If Rng2.Value = 0 Or Rng2.Value = "" Or Rng2.Offset(0, 3).Value = "Define" Or Sum(Rng2.EntireRow) = Rng2.Value Then
        Rng2.Value = Rng2.Offset(-1, 0).Value
    End If
Next
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.298729 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO