title: VBA: How to describe row with specific string
body: <p>Hi I'm trying to create a loop that identifies a specific string in column "B", and SUMs up the values in column "D" of the same row. So far I've been able to identify the "cash" but now I don't know how to describe column "D" of the SAME row and sum it up. Please help! </p>
  
  <p>Below is what I've got so far for this loop.</p>
  
  <pre><code>Dim CD As Long
  Dim text As String
  Dim Z As Long
  
  CD = 0
  
  For Z = 1 To Range("B" &amp; Rows.Count).End(xlUp).Row
      text = Range("B" &amp; Z).Value
      If Left(text, 4) = "Cash" Then
          Sum.... 
  </code></pre>